Source Preview

A source is a small dataset stored in a notebook. You can edit its values directly and join them with connection data from a SQL block.

INFO

This feature is in preview. To request access, contact Codatum support.

Creating and editing a source

You need edit permission on the notebook.

Creating a source by entering CSV

1. In Sources in the left sidebar, open Add, then select Create new under Source.
2. Enter values in CSV format and select a data type for each column.
3. Select Save.

Creating a source from a CSV file

1. In Sources in the left sidebar, open Add, then select Upload CSV under Source.
2. Select a UTF-8 CSV file.

A source belongs to its notebook. You can change its name and content from the source editor.

Referencing a source from SQL

Enter /source/ in a SQL block and select a source. Sources are supported in SQL for BigQuery, Snowflake, Databricks, and Redshift.

Select a source reference to change its Alias. Turn off Assign alias to the end to use an AS clause entered directly in the SQL.

Source values are included in the SQL sent for execution. The values might also appear in query history for the connection.

Deleting a source doesn't remove its references from SQL blocks. A reference to a deleted source becomes unresolved, and you can't run that SQL.

Data types and values

You can select one of the following data types for each column. You can't save CSV that contains values that don't match the format.

Data type	Value format
STRING	Any string.
INTEGER	Integer within the 64-bit integer range, e.g. -42.
FLOAT	Number, including exponent notation, e.g. 3.14 or 1e-3.
BOOLEAN	true or false (lowercase).
DATE	YYYY-MM-DD, e.g. 2026-08-25.
DATETIME	YYYY-MM-DDTHH:MM:SS with up to 6 fractional second digits, e.g. 2026-08-25T13:45:00.
TIMESTAMP	Datetime with Z or ±HH:MM, e.g. 2026-08-25T13:45:00+09:00.

An unquoted empty field is treated as NULL. A quoted empty string ("") is valid as an empty string for STRING, and invalid for the other data types.

Versions

Sources are included in versions. See the version specification for behavior when you inspect, restore, or create a notebook from a version.

Constraints

• A source name can contain up to 200 characters, and an alias can contain up to 128 characters.
• CSV must use UTF-8 and include a header row.
• A source can contain up to 100 columns and 10MiB.
• SQL can reference sources with up to 2,000 rows. You can save a source that exceeds 2,000 rows, but you can't run SQL that references it.
• A notebook can contain up to 100 sources.
• A notebook can retain up to 1,000 source revisions with a combined size of 1GiB.
• SQL, including expanded sources, can be up to 900KiB.
• Redshift can't reference sources whose values contain control characters other than tabs, line breaks, and a few others.
• You can't import or export a notebook that contains sources as a file.
• Table and Query result in dynamic options can't reference sources.
• Deleting a source reduces the source count usage. Revision count and storage usage are released later, so a revision quota can remain exceeded immediately after deletion.

See also the numeric limits.