Attach a Source
To attach a source to the Analytics Workspace, first make sure to select the Analytics Workspace in the connection selector:
Then click the “Add source” button:
The following overlay will show, where you can select the type of source to attach:
Here, you can attach local files from your computer, like CSV, JSON, Parquet & others.
After attaching the file, it will show up in the sidebar.
Left-click the sidebar entry to explore the file’s data. Or right-click it to start a new SQL query or copy the SQL identifier.
S3 or S3-compatible
Here, you can attach files from S3 or any S3-compatible object store like Cloudfare R2 or Google Cloud Storage.
- Alias: An arbitrary name under which you can later refernce the S3 source.
- File path: The URL of the file. Must be
http://. Should not be
Optionally, provide access key ID (user) and secret access key (password) if the resource needs authentication.
For other options, see Common File Options below.
After attaching the S3 source, it will show in the sidebar under the provided alias.
Left-click the sidebar entry to explore the source’s data. Or right-click it to start a new SQL query or copy the SQL identifier.
Common File Options
The format of your file.
Autofor automatic detection based on file extension.
- See all available formats in ClickHouse’s documentation
- Some common formats:
A comma-separated list of column name and data type pairs to manually define the table structure.
name String, user_id UInt32
After setting up a new connection or selecting an existing one, you must provide an alias for the attached connection:
Once the database is attached, you’ll see it in the sidebar under the given alias - in this example, under