Admin
Snowflake → D1 sync operations.
| Entity | Query | Status | Action |
|---|---|---|---|
Products | SELECT RANGEA.*, PRODS.*, BRANDS."Brand", SUPP."Supplier" FROM PARAMOUNTDATA.PUBLIC."ZZ_BottlestopRange" AS RANGEA INNER JOIN PARAMOUNTDATA.PUBLIC."Products" AS PRODS ON RANGEA."ProductID" = PRODS."ProductID" INNER JOIN PARAMOUNTDATA.PUBLIC."Brands" AS BRANDS ON PRODS."BrandID" = BRANDS."BrandID" INNER JOIN PARAMOUNTDATA.PUBLIC."Suppliers" AS SUPP ON PRODS."SupplierID" = SUPP."SupplierID" | — | |
Suppliers | SELECT * FROM PARAMOUNTDATA.PUBLIC."Suppliers" | — | |
Supplier Users | SELECT * FROM PARAMOUNTDATA.PUBLIC."Users" | — | |
Supplier–User Links | SELECT * FROM PARAMOUNTDATA.PUBLIC."SuppliersUsers" | — | |
Product Categorisations | SELECT * FROM PARAMOUNTDATA.PUBLIC."ZZ_ProductCategorisation" | — | |
Product Attributes | SELECT * FROM PARAMOUNTDATA.PUBLIC."ZZ_ProductAttribute" | — |