Data Catalog

Explore all tables Cybersyn offers through Snowflake Marketplace.

The Cybersyn Data Catalog is an index of all tables published across Cybersyn products on Snowflake Marketplace. CYBERSYN_DATA_CATALOG contains metadata about Cybersyn tables, including those from products you have not mounted, in one location to help you find the data you are looking for. You can start searching across datasets with our Streamlit dashboard or by accessing the table included in all Cybersyn data products.

Why is CYBERSYN_DATA_CATALOG useful?

  • You want a complete view of all Cybersyn datasets across all products.

  • You want to find datasets that Cybersyn recently added.

  • You want to understand how tables across products relate and can be joined.

  • You want more information about the sources that the data comes from.

Data Catalog Structure & Content

Example Use Cases & Queries

Discover new tables that Cybersyn recently released

Sort tables by their original creation date to find the newest tables that Cybersyn recently added to Snowflake Marketplace.

SELECT *
FROM cybersyn.cybersyn_data_catalog
ORDER BY created_date DESC;

Filter to all tables that include a specific entity type

Find the tables and sources with company-level granularity by filtering to all tables using the company_id entity.

SELECT *
FROM cybersyn.cybersyn_data_catalog
WHERE ARRAY_CONTAINS('company_id'::VARIANT, entities);

Search for tables by source

Search the table description and the data source for a specific keyword or source. In the example below, search for data coming from or related to the Census Bureau.

SELECT *
FROM cybersyn.cybersyn_data_catalog
WHERE description ILIKE '%Census Bureau%'
  OR TO_VARCHAR(data_source) ILIKE '%Census Bureau%';

Last updated

Copyright Β© 2024 Cybersyn