Replace Dataset
Existing Auto Insights datasets imported via Admin Portal, including Playbooks Synthetic datasets, and data ingested via the Designer Desktop Uploader tool can be connected to Analytics Cloud by linking to an Analytics Cloud dataset. Furthermore, Auto Insights datasets already connected to an Analytics Cloud Dataset can be switched to another Analytics Cloud dataset source.
Connecting an Auto Insights dataset to Analytics Cloud
Avis
Connecting an Auto Insights dataset to Analytics Cloud is a one-way action and cannot be undone, however, the below steps can be repeated to connect to a different Analytics Cloud dataset as needed.
Auto Insights datasets imported via Admin Portal are recommended to be connected to an Analytics Cloud dataset due to the benefits listed above.
To migrate an Auto Insights dataset and connect to an Analytics Cloud dataset or connect to a different Analytics Cloud dataset...
From the Datasets page, select the Dataset you want to connect to an Analytics Cloud dataset and select the ellipsis icon > Replace dataset.
Use the Replacement Analytics Cloud Dataset dropdown to select the Analytics Cloud Dataset that should be connected to this Auto Insights dataset, and select Next.
Compare the differences in structure between the current Auto Insights dataset and the proposed Analytics Cloud dataset. Differences in structure between the two datasets will be highlighted in the Missing Columns and New Columns sections, with details shown on the right after selecting the respective tab.
If existing columns are missing from the replacement dataset, Auto Insights will highlight that the replacement dataset is not recommended using a red banner as shown.
If no existing columns are missing from the new dataset, Auto Insights will confirm that the replacement dataset should not impact your current assets.
Review the Missions that may be impacted by the data replacement, including both those for which you are the owner or have access, as well as those to which you do not have access - for each of these categories, you will be able to see how many missions and/or subscriptions have been created which use this dataset. Select the checkbox and select Replace Dataset to proceed with the replacement.
Auto Insights will begin the process to import and analyze the new dataset from Analytics Cloud. You can hover your mouse cursor over the Analyzing… status to see the ingestion progress.
Once the ingestion has completed, the Analyzing… status will clear and the Dataset is ready to use. Click on the blue hyperlink to select this Dataset and navigate to Missions. All existing Missions referencing this dataset will automatically update with the latest data.
Alternatively, this journey can be started via the Use in Auto Insights option from the Datasets page in Analytics Cloud, which will navigate into Auto Insights...
If no Auto Insights dataset exists using this Analytics Cloud dataset, a new one can be created. If one or more Auto Insights datasets already exist, they will be listed allowing the user to select a dataset to launch.
To use the selected Analytics Cloud dataset as the source for another Auto Insights dataset, select Go to Replace dataset.
Use the Current Dataset dropdown to select the Auto Insights dataset that should be connected to the selected Analytics Cloud dataset, and select Next.
The above methods can also be used to connect an existing Auto Insights dataset with an Analytics Cloud source to a new Analytics Cloud dataset.
Benefits of Connecting Datasets to Analytics Cloud
The benefits of connecting to an Analytics Cloud dataset include:
Leverage Analytics Cloud Connections—Support for 70+ data sources including Databricks, S3, BigQuery, PostgreSQL, and more.
Tighter integration between Designer Cloud and Auto Insights—Cloud Workflow > Auto Insights Dataset > Mission > Insights.
Improved dataset refresh capabilities—Multiple refresh schedules per dataset, streamlined ingestion workflow, manual “refresh” action, and orchestrate dataset refresh on the success of previous Cloud workflow using Plans.
What to Expect When Connecting a Dataset to Analytics Cloud
Once an existing Auto Insights dataset (that was created via Admin Portal) has been connected to an Analytics Cloud dataset…
Sharing is configured via Analytics Cloud, and not within the Auto Insights Admin Portal. See Share a Dataset.
Avis
Users that have been granted owner or viewer access to the dataset via Admin Portal Groups will have their access transferred to Analytics Cloud.
Viewers that have been granted access to the dataset via “Public” Dataset Access (making the dataset accessible to all users in the workspace) will not have their access automatically transferred to Analytics Cloud. This dataset will need to be shared with all users requiring continued access to this dataset.
Dataset refresh schedules are configured via Analytics Cloud, and not within Auto Insights Admin Portal. See Schedule Data Refresh.
The dataset can be manually refreshed via the menu option on the Auto Insights Datasets page.
Editing of the dataset column configuration (column names, column attributes, measure sentiment, etc) is now available via the Columns page in Dataset Settings, and not via the Admin Portal.
The source (as shown in the Auto Insights Datasets page) will change from Auto Insights or Designer to Analytics Cloud.
Configuring Your Data Connections and Datasets in Analytics Cloud
Before your existing Auto Insights datasets can be connected to Analytics Cloud, you first need to configure Analytics Cloud with the respective data connections and/or datasets that Auto Insights will use.
Here are a few steps to connect to your data from Analytics Cloud:
Review dataset requirements—Review the recommendations for what types of data are most suitable for Auto Insights and the requirements for how your data should be structured. See Data Preparation.
Create connections—For each external datastore that contains data to be used in Auto Insights, you will need to create a connection from Analytics Cloud through which data will be accessed. See Connection Basics.
Connect to your data—When you import data into the Alteryx Analytics Cloud, you are creating a reference to a source of data. When the data is required for use (for example, in Auto Insights), the Alteryx Analytics Cloud reads the source data into the application for your use. See Connect to Data.