primo_dataschemas
    Updated 2023-03-26
    select distinct 'Flipside' datawarehouse
    , lower(table_catalog) table_catalog
    , lower(table_schema) table_schema
    , lower(table_name) table_name

    from
    (
    select * from arbitrum.information_schema.tables
    union all select * from avalanche.information_schema.tables
    union all select * from axelar.information_schema.tables
    union all select * from base.information_schema.tables
    union all select * from bsc.information_schema.tables
    union all select * from cosmos.information_schema.tables
    union all select * from crosschain.information_schema.tables
    union all select * from ethereum.information_schema.tables
    union all select * from external.information_schema.tables
    union all select * from flow.information_schema.tables
    union all select * from gnosis.information_schema.tables
    union all select * from near.information_schema.tables
    union all select * from optimism.information_schema.tables
    union all select * from osmosis.information_schema.tables
    union all select * from polygon.information_schema.tables
    union all select * from solana.information_schema.tables
    union all select * from terra.information_schema.tables
    union all select * from thorchain.information_schema.tables

    )
    where lower(table_schema) != 'information_schema'
    order by 1,2,3,4

    Run a query to Download Data