To write and run SQL interactively in Foundry, use SQL Studio. SQL Studio provides a dedicated workspace for exploring data, iterating on queries, and reading or writing tabular data with features such as autocomplete, inline error reporting, and result visualization.
SQL transforms provide an alternative for authoring data transformations with Spark SQL in Code Repositories. Use SQL transforms when you want to maintain SQL as part of a code repository rather than develop queries in an interactive editor. SQL transforms support filtering, aggregations, derivations, window functions, and other Spark SQL capabilities.