- Mais recentes
- Mais votos
- Mais comentários
To configure Redshift Query Editor V2 to utilize external schemas for auto-complete, you can follow these steps:
Open the Redshift Query Editor V2 in the AWS Management Console. Choose the "Editor" view and select the database you want to work with. In the tree-view panel, navigate to the external schema you want to utilize for auto-complete. Choose "Refresh autocomplete" to refresh the displayed suggestions when authoring SQL. To enable the auto-populated with a tab-to-complete functionality in Redshift Query Editor V2, you can use the keyboard shortcut or the "More" icon to access the "Refresh autocomplete" option. This will refresh the displayed suggestions when authoring SQL. The autocomplete suggestions are automatically activated or can be triggered by a simple shortcut within Amazon Redshift Query Editor V2. You can also turn on (or off) Autocomplete to show suggestions as you enter your SQL in the Editor preferences.
In Redshift Query Editor V2, you can use the following keyboard shortcuts to enable the auto-populated tab-to-complete functionality:
To trigger auto-complete: Press "Ctrl + Space" on your keyboard to invoke the auto-complete suggestions.
To complete the currently highlighted suggestion: Press "Tab" after the desired suggestion is highlighted to auto-complete the suggestion.
These shortcuts help streamline the SQL writing process in Redshift Query Editor V2, making it easier to utilize the autocomplete functionality and quickly select the suggested commands or keywords.
Conteúdo relevante
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há 2 anos
- AWS OFICIALAtualizada há um ano
- AWS OFICIALAtualizada há 2 anos
Hi Sandhya,
Thank you for your answer. However, it still does not seem to work.
To give more info, I have my tables and schemas defined in the AWS Glue Catalog. This shows up automatically in Redshift in the tree view as demonstrated below:
If I would like to select
ID
fromusers_table
I would need to fully type outSELECT id FROM awsdatacatalog.example_schema.users_table
I am able to find the "refresh auto-complete" at the top right three dots, however running this does not seem to change anything. Pressing "Ctrl +Space" after
FROM
does not offerawsdatacatalog
nor will it give meexample_schema
if I press it after theawsdatacatalog.