-
Selecting the latest file added in a folder using Python
Hi All, I would appreciate it if someone can provide me with a python script to select (read_csv) the latest csv file in a SFTP folder? Currently I am using the following script to read csv files from a SFTP folder, however when we have multiple files added in different dates, I would like to select only the latest one…
-
Passing Variable to a Filter Recipe
Hi, this seems pretty trivial but I can't seem to get it to work; I have declared a variable called "COBDate" = "2022-01-28" I can also select this variable within the filter recipe and DSS reports the correct value within the variables preview, however when executing a simple formula based filter such as; COBDate ==…
-
Change data source for a chart in a Dashboard
I'm trying to duplicate the existing charts in a dashboard. I would like the data for the new charts to come from a different table with the same column names in my project. How can I achieve this? Is it possible to edit the datasource that the chart is built on?
-
Documentation for Event Server column names
Hello Dataiku community, I am able to retrieve event server data on my side, however, am having some difficulty understanding what some of the columns mean. I was able to find the following resource for event server: How to Leverage Compute Resource Usage Data — Dataiku Knowledge Base and the discussion here was helpful as…
-
Best way to clean data for country meaning
I have a dataset which includes ISO 3166-1 alpha-3 country codes which are being detected properly, and full country names where about 14% are being flagged as not passing validation. Is there some place I can get the canonical list of country names dataiku uses for meaning? And if I can get that list, what's the most time…
-
Replace headers with other row in table imported from Google Sheet
Hi, I have imported a table from a Google Sheet using Dataiku's Google Sheet plugin. What I would like to do now is set the third row (with 'horodate' at the far left) as the headers row, and delete all rows above the third line. 1. How can I achieve this using one of Dataiku's built-in recipes? 2. Is there a way to do so…
-
How to keep only two decimal in an insight
Hello everyone, Please, could you let me know how to keep only two decimal ? The insight from a model (Visual analyses) and the metric is R2 score. Many thanks, in advance, Regards, Hugo
-
Don't allow simultaneous users on webapp
Hi, I have built a Bokeh public webapp in dataiku that allows the user to modify an existing Dataset and save the changes he makes onto the original dataset. To be sure of not having weird interactions with multiple users trying to modify the dataset at the same time, I would like to restrict the usage of the webapp to a…
-
Sync & update a Google Sheets File
Hi all, Maybe a silly questions, but I do not know if it's possible to do what I am trying to. I have installed the GSheets plugin to connect to a GSheets files that it's constantly adding new data. I also did a dataset (with recipe and a dashboard) last week with that file. I would like to know if it's possible to sync…
-
Dataiku Flow Migration to Higher Environments
Hi, We are migrating our Dataiku Flow (created using visual recipes) from the DEV environment to QA/PROD Environment. Also, we are using Snowflakes, S3, and other connections for picking or saving the data. Just wanted to know how these connections are handled (Snowflake, S3, etc.) when we do the migration process as we…
