Defining primary keys

moranbuying

• January 13, 2019 11:46

I thought, a couple of weeks ago, that there was a way in the web interface to specify primary keys like {key1}-{key2}. Now, I only see the option of choosing whether each field is primary or not. Was this an intended change? If so, is Panoply sure that the order of chosen keys is not important?

thanks

0

• 

  Jason Harris

  • January 17, 2019 17:24

  Hi there!

  I checked with our product team and no changes have been made to our platform.

  We have two areas where you can declare primary keys…see below:

  Here’s a shot of our Tables page

  

  Screen Shot 2019-01-14 at 10.50.14 AM.png786×631 44.3 KB

  and here’s the Data Sources page:

  

  Screen Shot 2019-01-14 at 10.43.11 AM.png1135×708 79 KB

  Here you can set the key as you describe.

  0
• 

  moranbuying

  • January 19, 2019 02:04

  Thanks. Is choosing the keys in the first area, the Tables page, equivalent to setting the primary key on the data source?

  If I choose field1 and field2 are both part of primary key in tables, is that the same thing as setting
  {field1}-{field2} on the data source?

  0
• 

  Jason Harris

  • January 22, 2019 17:40

  No, it’s not the same. For your use case, it’s best to specify PK in the data sources screen.

  0
• 

  moranbuying

  • March 06, 2019 10:35

  Thanks. What happens when these definitions (Tables vs Data Source) conflict?

  0

Please sign in to leave a comment.