| BTEQ scripts | Snowflake Scripting or Python (SnowConvert AI can output either), run by Airflow, dbt, Snowflake Tasks or the Snowflake CLI | .IF ERRORCODE, .GOTO, .EXPORT and .IMPORT logic, restarts and alerts must be rebuilt |
| TPT, FastLoad, MultiLoad, TPump | Files in cloud storage loaded with COPY INTO, or Snowpipe for continuous loads; MERGE for upserts | Upsert logic becomes MERGE; error tables and restart checkpoints need a new design |
| SET tables | Standard tables, which allow duplicate rows | Teradata silently drops duplicate rows; Snowflake keeps them, so loads must deduplicate (QUALIFY ROW_NUMBER() or MERGE) |
| MULTISET tables | Standard tables | Direct mapping; same duplicate behavior |
| Primary index (UPI, NUPI) | No indexes; automatic micro-partitions. Primary and unique keys can be declared but are not enforced | Uniqueness that a UPI enforced must be enforced in the pipeline or tested with dbt tests |
| Partitioned primary index (PPI) | Natural load order, or a clustering key on large tables | Add clustering keys only where query profiles show poor pruning; reclustering consumes credits |
| Secondary and join indexes | Search Optimization Service, materialized views or clustering keys | Rarely needed one-for-one; decide per query from DBQL evidence. Some need Enterprise Edition |
| Macros | Views for simple macros; stored procedures for parameterized ones | Multi-statement macros become procedures with explicit transactions |
| Stored procedures (SPL) | Snowflake Scripting procedures (or JavaScript/Python) | Cursors, handlers and dynamic SQL need engineer review |
| QUALIFY, SAMPLE, TOP | QUALIFY, SAMPLE and TOP are supported | Usually converts directly; check sampling semantics where results feed tests |
| Volatile tables | Temporary tables (session-scoped) | Multi-step scripts must keep one session in the orchestrator |
| Global temporary tables | Temporary or transient tables | Create them inside the job; definitions do not persist |
| COLLECT STATISTICS | Not needed | Remove from scripts; Snowflake maintains table metadata automatically |
| NOT CASESPECIFIC columns | Comparisons are case-sensitive by default | Use collation or UPPER(), or joins and filters return different rows |
| FORMAT clauses, date and PERIOD types | TO_CHAR / TO_DATE formats; PERIOD becomes two start and end columns | A common source of silent result differences |
| TASM workload management | Separate virtual warehouses per workload, multi-cluster warehouses and resource monitors | Size from DBQL workload profiles; set auto-suspend and credit limits early |
| Fallback, journals, backups | Time Travel and Fail-safe | Long retention on high-churn tables raises storage cost |