JSON
Read or write a JSON file from an S3, SFTP, SharePoint, or Databricks connection.
info
You can also use the upload file feature to use JSON files. These will be stored in the SQL warehouse configured in your fabric.
Parameters
| Parameter | Description |
|---|---|
| Location type | Location you want to connect from. |
| Select or create connection | Whether to select an existing connection, or to create a new one. |
| Filepath | The file path according to the connection type. |
Source properties
| Property | Description | Default |
|---|---|---|
| Description | Description of the table. | None |
| Multiple documents per file | Whether the file contains multiple JSON objects separated by newline. | False |
| Inference Data Sampling Limit | Maximum number of rows to sample for inferring the schema. | 0 |
Target properties
| Property | Description | Default |
|---|---|---|
| Description | Description of the table. | None |
| Multiple documents per file | Whether the file will contain multiple JSON objects separated by newline. | False |