Query Autocomplete

Hi Team,

As per the demo:

http://demo.redash.io/queries/143/source#table

The Redash support auto completion. It auto populate the table names and other keywords, However we are using AWS Ec2 ami instance to run the query and it did not auto populate the tables or the keywords. Please suggest if we need to enable it anywhere?

Hi,

I was able to auto populate using CTL + space.
Is it some caching or based on query cache it auto populate? I have to use it all the time to get the table name populated.

The demo instance runs the latest version while the EC2 AMI runs the latest stable version. In the latest version we improved the autocomplete experience compared to the one we had in previous versions. This is the reason you see a difference.

I have V9 and the autocomplete still doesnt work.

Hi @adi.raz :slightly_smiling_face:, two questions: 1 - What data source type are you querying? 2 - Does it show the table names and columns for this data source in the left side of the Query Editor page?

Hi

  1. snowflake
  2. yes

Are you certain that autocomplete is enabled? The lightning bolt glyph under the query editor has a strike-through when autocomplete is disabled.

This is the message that appears : “Live Autocomplete Not Available (Use Ctrl+Space to Trigger)”
and I tried Ctrl+Space and it still doesn’t work.

@susodapop @arikfr ?

Hey @adi.raz,

It’s unavailable when it’s a very large schema (with many tables and columns). Ctrl+Space should give you suggestions when you press it while writing the query (it should give you immediate suggestions).