You are viewing Query Studio - Query Builder documentation for Data Trust v7.6 (latest).
Looking for the previous version? View v2024.06 documentation →

Writing Queries on a Local CSV File

Write queries against a local CSV file using the Query Builder.

Overview

This guide walks through the Writing Queries on a Local CSV File workflow in Data Trust Query Studio. Follow the numbered steps below to configure, execute, and review the results.

Note: Ensure all required connection profiles are configured in the Administration module before building queries or Query Chains in this workflow.

Prerequisites

You are logged in to Data Trust with a Pro-User or Admin Pro-User role.
The relevant connection profiles have been configured in the Administration module.

Steps

Path: Data Trust › Query Studio › Writing Queries on a Local CSV File

existing or Connect to new

Figure 1: existing or Connect to new

This step shows existing or Connect to new in the Writing Queries on a Local CSV File workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Local tohgle button

Figure 2: Local tohgle button

This step shows Local tohgle button in the Writing Queries on a Local CSV File workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Configuration

Figure 3: Configuration

This step shows Configuration in the Writing Queries on a Local CSV File workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Preview and Override datatype

Figure 4: Preview and Override datatype

The Preview Data button fetches a sample of records from the selected table or query result. Verify the column names and sample values before proceeding to confirm the data source is correctly configured.

Select File

Figure 5: Select File

The Select File configures a CSV file as the data source for the query. Select the file connection profile, browse to the file location, and map the delimiter and header settings before saving.

Result

Figure 6: Result

This step shows Result in the Writing Queries on a Local CSV File workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.