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 | id | asset_id |
COLUMN NAME CHANGE
- in | id | asset_id |
COLUMN DEPRECATION
- in | 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.
Last updated