Materialization SQL(Materialization SQL(物化SQL))¶
The Materialization SQL card allows you to write SQL queries against materialization datasets in your analysis. The card uses SparkSQL syntax, functions, and operators.
The Materialization SQL card accepts any materialization card as input. You can also pass scalar values such as dates, numbers, strings, and booleans as inputs to parameterize your queries.
The Materialization 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.
Input type¶
Materialization, date, number, string, boolean
Output type¶
Materialization
Usage information¶
| Functionality | Availability |
|---|---|
| Standard Quiver card | Supported |
| Transform table transform | Unsupported |
中文翻译¶
Materialization SQL(物化SQL)¶
Materialization SQL(物化SQL)卡片允许您在分析中对物化数据集编写SQL查询。该卡片使用SparkSQL语法、函数和运算符。
Materialization SQL(物化SQL)卡片接受任何物化卡片作为输入。您还可以传递标量值(如日期、数字、字符串和布尔值)作为输入,以参数化您的查询。
Materialization SQL(物化SQL)卡片还支持AIP驱动的SQL生成。您可以用自然语言描述想要执行的分析,该卡片将为您生成SQL查询。
输入类型¶
物化数据、日期、数字、字符串、布尔值
输出类型¶
物化数据
使用信息¶
| 功能 | 可用性 |
|---|---|
| 标准Quiver卡片 | 支持 |
| 转换表变换 | 不支持 |