...
- Select the + (plus) at the top left of the File Browser and select Export Job or right-click on the workbook to export from and select Add to New Export Job.
Select the workbook to export from in the browser.
Select the worksheet to export from the drop down menu.
- Select the Snowflake connector.
- The Snowflake database name is that set in the connector. If not previously set from the connector, enter the Snowflake Warehouse name.
To export to an existing table on Snowflake, select the radio button Use Use existing. Choose a schema and table name from the drop-down lists.
To export to a new table or replace an existing table on Snowflake, select the radio button Create new or replace existing table. Choose a schema from the drop-down list and enter a new table name.
Select a record replacement policy. Learn more about database record replacement.- Replace records - All records from the existing table are deleted and the new records are written to the table. No table properties are modified.
- Append records - The records append (added in addition) to the existing table.
- Preview how the data to is being mapped to the Snowflake table and select how to handle invalid data.
- Select when to run the export job. This can be done manually by a user, run each time the workbook in Datameer is calculated, or at specifically scheduled times.
Custom properties can be added in the advanced section as well as logging specifications.
- Enter a description and click Save.
...