Andrey ✭✭✭✭✭✭✭

  • Re: Database

    AndreyAndrey
    Hi, Are you interested in some specific table/dataset? On the Dataiku side we track every time your dataset is built, one way to access this information is through the python API, for example: import…
    ·

  • Re: Filter recipe

    AndreyAndrey
    Hi @emate , I guess I wasn't clean enough in my previous answer. I was explaining the difference between 2 types of queries: country = "France" or country = "Germany" vs coun…
    ·

  • Re: Filter recipe

    AndreyAndrey
    yes, it makes sense to leave it as it is. (I just spotted that in the screenshot you have recordId next to France, not country - might be a small bug). Also, think about adding indices on the columns…
    ·

  • Re: Filter recipe

    AndreyAndrey
    Hi, The way filter recipe works is that based on your conditions DSS will generate a SQL query that will be executed in your database. Before executing a query databases build what's called an e…
    ·

  • Re: Formula for if an entry starts with

    AndreyAndrey
    Hi, Are you trying to process data using prepare recipe? if yes I could suggest using a "Replace" step. It allows you to define a regular expression patterns, so for the '053' -&g…
    ·
Avatar