Skip to content
Lucas Lessa
Voltar para as notícias
SnowflakePublic PreviewImpacto: Alto

Migrate SAS workloads to Snowflake using artificial intelligence

The Snowflake AIM Agent now supports SAS codebase assessment, code conversion to Snowflake SQL, and dataset file loading.

O que mudou

The Snowflake AIM Agent for Data Warehouses now assists in migrating legacy SAS environments directly to Snowflake. The tool uses AI to analyze code, convert SAS scripts into SQL, and load dataset files.### Use casesImagine you need to move legacy SAS reporting routines and scripts into Snowflake. You can use the agent's artificial intelligence to:- Assess the complexity and dependencies of your SAS codebase before touching any code.- Convert SAS programs into Snowflake SQL commands with logic validation.- Load SAS dataset files in .sas7bdat format directly into Snowflake tables.### How to useAsk the Snowflake AIM Agent for Data Warehouses directly using natural language. For example:```sql "Assess my SAS codebase for a Snowflake migration"

1. The agent scans the SAS codebase or directory.
2. It generates a report covering complexity, volume, and dependencies.
3. The team plans the migration based on the findings.Another example:```sql
"Convert this SAS program to Snowflake SQL"
```What happens in this code:
1. The agent takes the provided SAS program.
2. It converts the logic to Snowflake SQL using an AI approach.
3. The system runs a validation step to check the converted logic.Another example:```sql
"Load this SAS dataset into Snowflake"
```What happens in this code:
1. The agent identifies the .sas7bdat dataset file.
2. It triggers the loading process to ingest the data into a Snowflake table.### Limitations and requirementsAvailable in Public Preview for all accounts. SAS code conversion is AI-based only (no deterministic grammar-based conversion yet). Integrations with testing frameworks, cloud migration frameworks, and Power BI report repointing are not currently included.### Using it in a pipelineUse this feature during the initial legacy modernization phase to assess SAS codebases, translate business logic into Snowflake SQL, and populate initial bronze layer tables.
Ver nota oficial do Snowflake

SAS to Snowflake migration (Preview)

Resumo e explicação gerados por IA a partir da release note oficial. Em caso de dúvida, a documentação oficial da plataforma prevalece.

Relacionadas