The Dataset SQL card allows you to write SQL queries against datasets in your analysis. The card uses SparkSQL syntax, functions, and operators.
The Ontology SQL card is the recommended approach for writing SQL against object sets. Use the Dataset SQL card as a fallback for cases when Ontology SQL is not suitable, such as for certain operations that are not supported by Ontology SQL.
The Dataset SQL card accepts any dataset card as input. You can also pass scalar values such as dates, numbers, strings, and Booleans as inputs to parameterize your queries.
The Dataset SQL card also supports AIP-powered SQL generation. You can describe the analysis you want to perform in natural language, and the card will generate a SQL query for you.