Export

It is easy to setup a dataset for export, when you wish to take data from LityxIQ to upload into other applications. First, select the dataset from the list of available datasets in the Data Manager. From the Selected Dataset menu or after right clicking the dataset, click Export, then Export Settings. This will open the Export Settings dialog. Its four tabs are described below. Export Location Tab - Export Location - select the location where you would like to place the expor...

To run a dataset export, you must first create export settings (see https://support.lityxiq.com/002683-Export-a-Dataset---Settings) (https://support.lityxiq.com/002683-Export-a-Dataset---Settings) Then, you have the option of executing the export manually, or scheduling it (including automating the export process). Executing a Dataset Export Manually Select the dataset from the list of available datasets, click the Selected Datasets menu button, click Export, then click Export Now. Y...

If you are having trouble with Snowflake (https://support.lityxiq.com/189302-Trouble-with-Snowflake) LityxIQ supports the ability to directly export a LityxIQ dataset into your Snowflake account. This can be used, for example, as a way to create Tableau dashboards that automatically refresh upon fresh data being created in LityxIQ. All dataset exports in LityxIQ start by setting its Export Settings. For general information on Export Settings, see https://support.lityxiq.com/002683-Export-a-Dat...

A couple of items to double check if you are having issues . . . If you have a successful connection between LityxIQ and Snowflake, and exporting data from Lityx to the Snowflake server is working great, but you can’t figure out how to get Snowflake data into LityxIQ. The connect is working, but for some reason no tables in the database are showing up in the LityxIQ platform. ANSWER: specify a compute warehouse in the Lityx connection details pane. When trying to write to Snowflake: If LityxIQ...