Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://docs.databricks.com/aws/en/sql/language-manual/functions/schema_of_csv below:

schema_of_csv function | Databricks Documentation

Applies to: Databricks SQL Databricks Runtime

Returns the schema of a CSV string in DDL format.

schema_of_csv(csv [, options] )

• csv: A STRING literal with valid CSV data.
• options: An optional MAP literals where keys and values are STRING.

A STRING composing a struct. The field names are derived by position as _Cn. The values hold the derived formatted SQL types. For details on options see from_csv function.

SQL

> DESCRIBE SELECT schema_of_csv('1,abc');
 STRUCT<`_c0`: INT, `_c1`: STRING>

• from_csv function

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4