Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Visual query builder icon definitions

Pingu
10 - Fireball

Hi all,

 

I am struggling a bit with the correct names for some icons when using InDB connectoins and the visual Query Builder. I tried to google it but I could not find the official lingo.

 

What are the correct names for these 4 icons?

 

names.png

 

 

Many thanks.

4 REPLIES 4
VojtechT
Alteryx
Alteryx

My guess would be Database -> Schema -> Table -> Column.

Vojta T., PM for Data Connectors
Try our Beta data connectors at https://bit.ly/3Ae8HgY
Pingu
10 - Fireball

Thanks. Schema seems about right. Googling it: ''The term "schema" refers to the organization of data as a blueprint of how the database is constructed (divided into database tables in the case of relational databases)". For Column I also hear people use the word Field! I thought it might be label with the icon hehe.

jeprime
8 - Asteroid

Along the same lines, and this may be an easy question to answer: on the column icon, what does it mean when it has red inside it. It shows a key next to the variable selection box in the Query Builder?

variable with red.png

keys next to variables.png

aihnen
8 - Asteroid

That should be the primary key columns associated with that table. They are the column or combination of columns that uniquely identifies each row in a table. No two rows can have the same key and keys should not ever be null. They provide structure and reliability of the table data by preventing duplicate records and also usually identify the level of detail of the table. 

 

Labels
Top Solution Authors