After designing queries using Treasure Data, you might want to export the results of those queries to another application. The data that you export might be used as part of another downstream process or simply used to generate charts that are meaningful to your business.
You might see the term Export Results used in association with export activities. Export Results allow you to send the results of a query to a destination. Integrations are used to export query results out from Treasure Data to the target destination. As with import, you must create and configure the data connection to be used during export, prior to running your query.
- Creating a Source and Authentication for your Data Export
- Creating a Query for your Data Export
- Running a Result Export Job
- Using a Workflow to Export Results
Your authentications permissions can affect your ability to export results to a destination.
Open TD Console.
Navigate to Integrations > Catalog.
Optionally, use the filters to refine the catalog type.
Select one of the options listed.
Complete the fields for your Integration type. The required field varies based on the type of data connector that you want to implement.
Select Continue.
Optionally, specify additional configuration details.
Select Done.
To create a new result data export
Navigate to Data Workbench > Queries.
Select or create a new query for which you want to export the results.
Queries without a name in the Destination column, have no Result Export setup.
Make sure that Export Results To is selected. For example:
Optionally, select the link to see details. For example, select 111_g_sheets_beta_01_gs.
- Run the query to generate results and export them to the targeted location. For more information on running or viewing jobs using Treasure Data, see jobs.
Learn how to use a workflow to run a query and export results.