Query remote CSV File

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

Data Trust › Query Studio › Query Builder

Query a Remote CSV File

Query a CSV file hosted on a remote FTP or shared drive connection.

Overview

This guide walks through the Query a Remote 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 › Query a Remote CSV File

Figure 1: CSV Query screen

The CSV Query screen 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.

Figure 2: after clicking on test connectoin

This step shows after clicking on test connectoin in the Query a Remote CSV File workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.

Figure 3: Preview Data & Confirm Metadata

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.

Figure 4: navigator

The Navigator panel displays the available databases, schemas, and tables for the selected connection. Expand the tree to locate the required table, then click Select to add it to the query.

Figure 5: CSV Query execution

The CSV Query execution 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.

Figure 6: info

This step shows info in the Query a Remote CSV File workflow. Follow the on-screen prompts to complete this configuration step before proceeding to the next stage.