import json - looker studio

[mvrangel]

Guys, could you help me?

I'm developing a project in Python and SQL using Replit. I did a select and converted the data to json. Now I need to import this Json data into Looker Studio, however, I am not able to do so.

Can anyone tell me how to do this import?

[Francesco_V]

You might consider JSON custom connectors or import data in BigQuery as JSON type (or regular table) 

[Carlos_Leon]

Depending on the amount of data, you can export the data to Google Sheets using pandas and the Google Sheets API. SQL can offer better performance if the data exceeds Google Sheets limits. Another option is using an external connector like windsor.ai.