codeant-ai-for-open-source[bot] commented on PR #37311:
URL: https://github.com/apache/superset/pull/37311#issuecomment-3781152108
## **Sequence Diagram**
When importing example datasets, the importer automatically transpiles a
dataset's SQL to the target database dialect (via SQLGlot) before creating the
dataset, ensuring cross-dialect compatibility. The diagram shows the main
success path added in this PR.
```mermaid
sequenceDiagram
participant Importer as ImportExamplesCommand
participant DB as Database (ORM)
participant Transpiler as transpile_to_dialect (SQLGlot)
participant DatasetService as import_dataset
Importer->>Importer: Iterate dataset config (has SQL)
Importer->>DB: Query Database by database_id
DB-->>Importer: Database (with engine)
Importer->>Transpiler: transpile_to_dialect(sql, target_engine)
Transpiler-->>Importer: transpiled_sql
Importer->>DatasetService: import_dataset(config with transpiled SQL)
DatasetService-->>Importer: created dataset
```
---
*Generated by [CodeAnt AI](https://codeant.ai)*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
