Help Center/ Data Lake Insight/ FAQs/ SQL Jobs/ SQL Job Development/ How Do I Create a Table Using JSON Data in an OBS Bucket?
Updated on 2025-03-17 GMT+08:00
How Do I Create a Table Using JSON Data in an OBS Bucket?
To associate JSON data nested in an OBS bucket, you can create a table in asynchronous mode.
The following is an example of a table creation statement that shows how to use JSON format options to specify the path in OBS:
create table tb1 using json options(path 'obs://....')
- using json: JSON format is used.
- options: used to set table options.
- path: path of the JSON file in OBS.
Parent topic: SQL Job Development
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
