Data Here, Data There, Data Everywhere. I am sharing few cool job offers where you can meet both Keboola and Keboolians. If you are interested, I am happy to share some behind-the-scenes information or connect you directly to a hiring manager.

I start with our own job offering:
Keboola - Data Consultant - https://bit.ly/3smmRd4 in the team led by the best Martin Fiser.

And:
Košík.cz - Data Engineer/Data Analyst - https://bit.ly/3vZt4Ow
Seznam.cz - Data Analyst for Marketing - https://bit.ly/3ym94qH
Bonami - BI/Data Analyst - https://bit.ly/395wOVn
intecs data, s.r.o.- BI Specialist - https://bit.ly/3N37lec
Heureka.cz / sk - Data analyst - https://bit.ly/3sn1Rmm
Productboard - Data Engineer - https://bit.ly/395rfXl
GLAMI - Data Analyst - https://bit.ly/38h1zXB
ZOOT a.s. - Data analyst - https://bit.ly/3kUxi3x
Pale Fire Capital - Analyst - https://bit.ly/3ytAmLV
Ušetřeno.cz s.r.o. - Data analyst - https://bit.ly/3M1DTVF
Global Payments CZ - Junior Data Analyst - https://bit.ly/3P6t6LP

#IAmNotHR #IAmNotaHeadhunter #IJustTalkToKeboolaCustomers

Following the previous community post that primary keys cannot be null in Snowflake anymore, we would like to inform you that Snowflake is going to release this constraint in the following order: 

• September 1, 2021 for https://connection.north-europe.azure.keboola.com/
• September 2, 2021 for https://connection.keboola.com/
• September 3, 2021 for https://connection.eu-central-1.keboola.com/

We hope you managed to update all the necessary primary keys so this release does not cause you any problems. 

As you know, currently we don’t charge customers for usage of the legacy Data Science Sandboxes (marked as BETA) because they have not been fully under your control.

We have already released a new stable and complete environment of Data Science Workspaces with full control over the usage for Keboola users. New Data Science workspaces enable: 

• Input mapping: Data can be loaded into the existing workspace.
• Output mapping: Data can be unloaded from the workspace to the storage.
• Multiple workspaces: You can now have as many workspaces as you need. Not just one sandbox as in the past. 
• Workspaces can be shared within all the users in the project.
• Backend size can be chosen according to your needs.
• There is an auto-sleep function, which can be turned on or off.

We will start including the new Data Science Workspaces usage into your credit consumption from August 1st 2021 (what is time credit and how it is calculated). And since we start turning off the old Sandboxes, we would like to ask you to move over the new ones as soon as you can.

If you are using our Telemetry Data extractor you can easily measure the consumption by using the table “kbc_data_science_sandbox”. To be able to adjust and review your usage, only new Data Science Workspaces are included in your billed credits.  

In case of any questions, please reach out to your Customer Success Manager (if we were not faster :o).

We have noticed many projects and configurations may be affected by the last Snowflake update. Snowflake implemented a “NOT NULL” constraint on columns set as primary keys. See this announcement for further details. 

How it appears in the Keboola connection: When the column is marked nullable in metadata, we create it nullable in the workspace. Also by default we enable "convert empty strings to null" in the UI.

Action required: You need to update all the primary keys not to be “null”. Otherwise it would result in a "null in a not nullable column" error. When the column is no longer nullable, the previous NULL values will become empty strings and will no longer be unique. Please, check the detailed comment under this post describing the scenario that can occur.

Timing: Keboola managed to postpone the rollout of the change for everyone using Keboola provided Snowflake until 31st August 2021, to allow time to take action. This is a hard deadline set by Snowflake. If you’re using your own Snowflake you need to either fix the configurations or get in touch with Snowflake support.

What can help: There is a warning on your Dashboard for projects and configurations affected by this Snowflake update. In case of any questions, please reach out to our support team.