Using ADS
This section describes how you interact through Alteryx Analytics Cloud (AAC) with your Alteryx Data Storage (ADS) environment.
Alteryx Data Storage (ADS) is a data storage service provided by Alteryx for use in AAC.
ADS provides S3-backed storage services for importing, storing, sampling, and generating results.
ADS is enabled as the default storage environment for your product.
Optionally, you can set S3 to be the default storage environment and enable ADS as a secondary storage environment.
For more information, see Configure Storage Environment.
Uses of ADS
AAC can use ADS for the following tasks:
Creating Datasets from Files: You can read in source data stored in ADS. An imported dataset may be a single ADS file or a folder of identically structured files. See Reading from Sources below.
Reading Datasets: When creating a dataset, you can pull your data from a source in ADS. See Creating Datasets below.
Writing Results: After a job has been executed, you can write the results back to ADS. See Writing Results below.
As default storage environment: If ADS is your default storage environment, additional data is stored by operations of AAC. See Configure Storage Environment.
In AAC, ADS is accessed through the ADS browser. See ADS Browser.
Note
When AAC executes a job on a dataset, the source data is untouched. Results are written to a new location, so that no data is disturbed by the process.
Before You Begin Using ADS
Warning
Avoid using /trifacta/uploads for reading and writing data. This directory is used by AAC.
Your writeable home output directory is available through your user profile. See Storage Page.
Secure Access
Access to ADS is governed by IAM roles that are automatically assigned to workspace users of the product. No additional configuration is necessary to access ADS.
Storing Data in ADS
When you upload raw data to ADS, it is stored in your pre-configured uploads directory based on an internal upload identifier.
All Alteryx users should have a clear understanding of the folder structure within ADS where each individual can read from and write results.
Users should know where shared data is located and where personal data can be saved without interfering with or confusing other users.
AAC stores the results of each job in a separate folder in your ADS location.
Note
AAC does not modify source data in ADS. Source data stored in ADS is read without modification, and source data uploaded to AAC is stored in /trifacta/uploads.
Reading from Sources
You can create an imported dataset from 1 or more files stored in ADS.
Wildcards:
You can parameterize your input paths to import source files as part of the same imported dataset.
Folder selection:
When you select a folder in ADS to create your dataset, you select all files in the folder to be included.
Notes:
This option selects all files in all sub-folders and bundles them into a single dataset. If your sub-folders contain separate datasets, you should be more specific in your folder selection.
All files used in a single imported dataset must be of the same format and have the same structure. For example, you cannot mix and match CSV and JSON files if you are reading from a single directory.
When a folder is selected from ADS, the following file types are ignored:
*_SUCCESSand*_FAILEDfiles, which may be present if the folder has been populated by the running environment.
Note
If you have a folder and file with the same name in ADS, search only retrieves the file. You can still navigate to locate the folder.
Creating Datasets
When creating a dataset, you can choose to read data in from a source stored from ADS or local file.
ADS sources are not moved or changed.
Local file sources are uploaded to
/trifacta/uploadswhere they remain and are not changed.
Data may be individual files or all of the files in a folder.
For more information, see Reading from Sources in ADS above.
See Import Data Page.
Writing Results
When you run a job, you can specify the file path where the generated results are written. By default, the output is generated in the default output home directory.
Each set of results must be stored in a separate folder within your ADS output home directory.
For more information on your output home directory, see Storage Page.
Creating a new dataset from results
As part of writing results, you can choose to create a new dataset, so that you can chain together data wrangling tasks.
Note
When you create a new dataset as part of your results, the file or files are written to the designated output location for your user account. Depending on how your permissions are configured, this location may not be accessible to other users.
Purging Files
Other than temporary files, AAC doesn't remove any files that were generated or used by the platform, including:
Uploaded Datasets
Generated Samples
Generated Results