Any way to avoid repeatedly typing data source and project information for every table in a GCP query?

For every table I query on my GCP data source I have to fully qualify the entire path each time, so instead of just being able to do something like

SELECT * from TABLE_NAME

I have to enter

SELECT * FROM `FULL_DATA_SOURCE_PATH.FULL_GCP_PROJECT.TABLE NAME`

Is there a way to set a default data source path and project name so I do not have to do this each time? In the “Schemas” section of the data source properties I only have the default data source and project that I use to filter down on all of the options, its the only place I saw to filter things down but it still requires the full path each time for each table in every query. 

0
Hi James,

I believe you're referring to resolving objects, forcing you to fully qualify objects in your queries. If that's the case, we are likely talking about the code completion settings. Please check Suggest Objects From in File | Settings | Editor | General | Code Completion and consider setting it to All available schemas option. Judging by the description, it looks like you're using the current scope option, where object names coming from other schemas / databases need to be fully qualified.   
0

请先登录再写评论。