You can import one or more tables from relational sources into the Alteryx One.
Note
When you import a file, the data is not stored in the Alteryx One. What you create is an imported dataset, which is simply a reference to the source of the data. The Alteryx One never stores or modifies source data.
Steps:
From the menu bar, select Data page.
From the left sidebar in the Import Data page, select the connection to the relational datastore where your data is located.
Browse the relational datastore to locate the table that you wish to import.
Note
You must have read permissions on any database and table that you wish to import.
Create Dataset with SQL: You can apply a custom SQL statement to import from a database. For more information, see Create Dataset with SQL.
When you are ready to complete the import process.
Your tables are available as imported datasets.
For more information, see Import Data Page.