As part of our ongoing efforts to optimize our data infrastructure and improve performance, we're migrating to a new Snowflake Listings service, which will be powered by a new Snowflake account. This migration includes deprecating columns that are no longer actively maintained, or have been replaced with more efficient alternatives.
Affected areas include:
- Transaction and Order Data: Several legacy columns in TRANSACTION_ITEMS and ORDER_ITEMS tables
- Account Information: Patient type and payment user flags in ACCOUNTS table
- Inventory/Batch Tracking: Several changes to BATCH_PLANT_IDS table, removing numerous processing and tracking fields
- Point of Sale: Device identifiers in POS_TERMINAL_INFORMATION
- Product Data: Image and NDC-related columns in PRODUCTS table
The identified columns are being retired because they’re no longer used by Dutchie’s applications and have been removed from our database systems. No new data will be written to these columns going forward.
Action Required
Please review your queries, reports, and integrations to ensure they don't rely on these deprecated columns. If you're currently using any of these columns, you'll need to:
- Update your queries to remove references to deprecated columns
- Modify any dashboards or reports that depend on these fields.
| TABLE | COLUMN | COLUMN REFERENCE |
| TRANSACTION_ITEMS | MIGRATEDFROMINVID | TRANSACTION_ITEMS.MIGRATEDFROMINVID |
| DISCOUNTS | ALLOWLOYALTYACCRUAL | DISCOUNTS.ALLOWLOYALTYACCRUAL |
| POS_TERMINAL_INFORMATION | PAYNETWORXDEVICEID | POS_TERMINAL_INFORMATION.PAYNETWORXDEVICEID |
| ORDER_ITEMS | LOCID | ORDER_ITEMS.LOCID |
| ORDER_ITEMS | LSPID | ORDER_ITEMS.LSPID |
| PURCHASE_ORDER_ITEMS | BATCHID | PURCHASE_ORDER_ITEMS.BATCHID |
| ACCOUNTS | PATIENTTYPE | ACCOUNTS.PATIENTTYPE |
| ACCOUNTS | ISDUTCHIEPAYUSER | ACCOUNTS.ISDUTCHIEPAYUSER |
| BATCH_THC | LABINVID | BATCH_THC.LABINVID |
| TBL_CHARGECODESSET | CHARGECODES_CODE | TBL_CHARGECODESSET.CHARGECODES_CODE |
| LSP_LOCATIONS | VENDORID | LSP_LOCATIONS.VENDORID |
| BATCH_PLANT_IDS | RUSER | BATCH_PLANT_IDS.RUSER |
| BATCH_PLANT_IDS | SFEUSER | BATCH_PLANT_IDS.SFEUSER |
| BATCH_PLANT_IDS | BIRTHDT | BATCH_PLANT_IDS.BIRTHDT |
| BATCH_PLANT_IDS | NOTES3 | BATCH_PLANT_IDS.NOTES3 |
| BATCH_PLANT_IDS | NOTES1 | BATCH_PLANT_IDS.NOTES1 |
| BATCH_PLANT_IDS | WEIGHTAFTERSIFTING | BATCH_PLANT_IDS.WEIGHTAFTERSIFTING |
| BATCH_PLANT_IDS | VEGATATIVEDATE | BATCH_PLANT_IDS.VEGATATIVEDATE |
| BATCH_PLANT_IDS | RELEASEDFLAG | BATCH_PLANT_IDS.RELEASEDFLAG |
| BATCH_PLANT_IDS | REXTRACTORTEMP | BATCH_PLANT_IDS.REXTRACTORTEMP |
| BATCH_PLANT_IDS | FFILLTANKFINISHWGT | BATCH_PLANT_IDS.FFILLTANKFINISHWGT |
| BATCH_PLANT_IDS | CUREDATE | BATCH_PLANT_IDS.CUREDATE |
| BATCH_PLANT_IDS | SFENEWFILLTANKSTARTWGT | BATCH_PLANT_IDS.SFENEWFILLTANKSTARTWGT |
| BATCH_PLANT_IDS | SFEFILLTANKSTARTWGT | BATCH_PLANT_IDS.SFEFILLTANKSTARTWGT |
| BATCH_PLANT_IDS | FLOWERDT | BATCH_PLANT_IDS.FLOWERDT |
| BATCH_PLANT_IDS | WEIGHTAFTERGRINDER | BATCH_PLANT_IDS.WEIGHTAFTERGRINDER |
| BATCH_PLANT_IDS | LOCBEFOREDEL | BATCH_PLANT_IDS.LOCBEFOREDEL |
| BATCH_PLANT_IDS | FPREPURGEWGT | BATCH_PLANT_IDS.FPREPURGEWGT |
| BATCH_PLANT_IDS | LOCDELDTTM | BATCH_PLANT_IDS.LOCDELDTTM |
| BATCH_PLANT_IDS | ADDCOL | BATCH_PLANT_IDS.ADDCOL |
| BATCH_PLANT_IDS | FLOWERINGDATE | BATCH_PLANT_IDS.FLOWERINGDATE |
| BATCH_PLANT_IDS | MOTHERSERIALNO | BATCH_PLANT_IDS.MOTHERSERIALNO |
| BATCH_PLANT_IDS | RHOMETANKSTARTWGT | BATCH_PLANT_IDS.RHOMETANKSTARTWGT |
| BATCH_PLANT_IDS | FUSER | BATCH_PLANT_IDS.FUSER |
| BATCH_PLANT_IDS | ITEMNUM | BATCH_PLANT_IDS.ITEMNUM |
| BATCH_PLANT_IDS | FWEIGHT | BATCH_PLANT_IDS.FWEIGHT |
| BATCH_PLANT_IDS | FHOTTANKFINISHWGT | BATCH_PLANT_IDS.FHOTTANKFINISHWGT |
| BATCH_PLANT_IDS | INITIALINTAKEWGT | BATCH_PLANT_IDS.INITIALINTAKEWGT |
| BATCH_PLANT_IDS | TRANSFERBATCH | BATCH_PLANT_IDS.TRANSFERBATCH |
| BATCH_PLANT_IDS | RSEPERATORTEMP | BATCH_PLANT_IDS.RSEPERATORTEMP |
| BATCH_PLANT_IDS | FINALINTAKEWEIGHT | BATCH_PLANT_IDS.FINALINTAKEWEIGHT |
| BATCH_PLANT_IDS | RSEPRERATORPSI | BATCH_PLANT_IDS.RSEPRERATORPSI |
| BATCH_PLANT_IDS | RUNNUMBER | BATCH_PLANT_IDS.RUNNUMBER |
| BATCH_PLANT_IDS | SFEHOMETANKSTARTWGT | BATCH_PLANT_IDS.SFEHOMETANKSTARTWGT |
| BATCH_PLANT_IDS | EXCESSWEIGHTTHATDIDNTFIT | BATCH_PLANT_IDS.EXCESSWEIGHTTHATDIDNTFIT |
| BATCH_PLANT_IDS | FHOMETANKLOST | BATCH_PLANT_IDS.FHOMETANKLOST |
| BATCH_PLANT_IDS | RFILLTANKSTARTWGT | BATCH_PLANT_IDS.RFILLTANKSTARTWGT |
| BATCH_PLANT_IDS | TRANSFERID | BATCH_PLANT_IDS.TRANSFERID |
| BATCH_PLANT_IDS | VEGDT | BATCH_PLANT_IDS.VEGDT |
| BATCH_PLANT_IDS | NOTES2 | BATCH_PLANT_IDS.NOTES2 |
| BATCH_PLANT_IDS | FHOTPLATETEMP | BATCH_PLANT_IDS.FHOTPLATETEMP |
| BATCH_PLANT_IDS | REXTRACTORPSI | BATCH_PLANT_IDS.REXTRACTORPSI |
| BATCH_PLANT_IDS | FTOTALTIMERAN | BATCH_PLANT_IDS.FTOTALTIMERAN |
| BATCH_PLANT_IDS | RNEWFILLSTARTWGT | BATCH_PLANT_IDS.RNEWFILLSTARTWGT |
| BATCH_PLANT_IDS | WEIGHTAFTERDEBRISREMOVAL | BATCH_PLANT_IDS.WEIGHTAFTERDEBRISREMOVAL |
| BATCH_PLANT_IDS | TRANSFERDATE | BATCH_PLANT_IDS.TRANSFERDATE |
| TRANSACTIONS | ZONEID | TRANSACTIONS.ZONEID |
| PRODUCTS | WHSEPRODUCT_IMAGE | PRODUCTS.WHSEPRODUCT_IMAGE |
| PRODUCTS | TRUNCATEDNDC | PRODUCTS.TRUNCATEDNDC |