JSON
Read or write a JSON file from an external 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.
Supported connections
Parameters
| Parameter | Tab | Description |
|---|---|---|
| Connection type | Type | Location you want to connect from. |
| Format type | Source location | Format of the gem. In this case, json. |
| Select or create connection | Source location | Whether to select an existing connection, or to create a new one. |
| Filepath | Source location | File path where you want to read and write files according to the connection type. |
| Properties | Properties | Optional table properties to apply. Source and target properties are outlined below. |
| Schema | Properties | Schema definition of the table (custom or inferred). |
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 |