Action for Data Share Users

Pricing data updates and actions required for users leveraging Flipside Snowflake Data Shares.

There are two key actions Data Shares customers need to take during Flipside’s pricing updates. They are outlined below in Action #1 and Action #2 sections.

Action #1: Replace old tables and column with optimized tables

Leverage our new pricing tables and deprecate the old ones by June 3rd, 2024. You need to change these table and column names in your queries so they don’t break. This affects 2 tables and 3 columns for 19 databases.

The following chains are affected:

Aptos	Flow
Arbitrum	Gnosis
Avalanche	Metadata Schema
Aurora	Near
Axelar	Optimism
Base	Osmosis
Bitcoin	Polygon
Blast	SEI
BSC	Solana
Ethereum

The table and column names that need to be deprecated for those 19 chains:

Type	Current name	New name
TABLE NAME CHANGE	fact_hourly_token_prices	fact_prices_ohlc_hourly
TABLE NAME CHANGE	ez_hourly_token_prices	ez_prices_hourly
COLUMN NAME CHANGE - in ez_asset_metadata	id	asset_id
COLUMN NAME CHANGE - in dim_asset_metadata table	id	asset_id
COLUMN DEPRECATION - in dim_asset_metadata table	decimals	No replacement, column is being deprecated

Remember, you must update these tables and column names by June 3rd, 2024 or your queries will break

Action #2: Monitor data pipeline for refreshed data on June 3rd, 2024

Any table that includes the amount_usd column will be refreshed on June 3rd, 2024 to include historical pricing. This will cause the modified_timestamp column to update.

If you are incrementally loading data utilizing the modified_timestamp column, you could see larger than normal data loading on June 3rd. Please make necessary preparations and keep an eye on your data pipelines on this day.

The following chains are affected:

Aptos	Ethereum
Arbitrum	Gnosis
Avalanche	Metadata Schema
Base	Optimism
Blast	Polygon
BSC

We will send you an email as we get closer to remind you.

Bonus: How to get improved token prices

To pull pricing data from 15,000+ tokens from CoinGecko, CoinMarketCap, and various other sources into your queries, use the (named Meta in Snowflake) and query select * from database.price.ez_prices_hourly to select any token from the available list.