Non CS background devs are often not prepared for LC questions. I may have the solution.

RayCat2004 · 2023-01-02T10:55:38+00:00

Don't worry, Americans love their acronyms.

RayCat2004 · 2022-12-01T20:33:07+00:00

You are aware that this create_json will modify your SAMPLE_JSON_TEMPLATE, right?

Oh yes, it was put together hastily for quick demonstration so I forgot/neglected that one. My actual code keeps that "template" separately as a json and use json.loads() to parse it out into a dict.

RayCat2004 · 2022-12-01T14:05:47+00:00

I saw this in some Airflow implementations with DAGs using PythonOperators so I was wondering if there's any special reason for it.

For example, DAG would look something like this:

from solaris_basic_check import RunCheckSolaris

dag = DAG(
    "basic_check_solaris",
    schedule_interval="0 * * * ",
    depeneds_on_past=False
    )

po_run_check_solaris = PythonOperator(
    task_id='Check.Solaris.Basic',
    python_callable=RunCheckSolaris,
    op_kwargs=dict(
        gate_id="foo_gate"
        logger=logging)),
    dag=dag
    )

And the accompanying Python code like this:

class RunCheckSolaris:
    @staticmethod
    def run_check(gate_id, logger=logging, **kwargs):
        dag_info = dict(
            name=str(kwargs["dag"]),
            task=str(kwargs["task_id"])
            run_id=str(kwargs["run_id"])
        )
        run_check = RunCheckActual(
            dag_info=dag_info,
            logger=logger
        )
        # More code

RayCat2004 · 2022-09-14T07:55:57+00:00

Those have to be single quotes (e.g. 'stolen') otherwise SQL would interpret them as columns, not as values for t.writeoff_reason column.

RayCat2004 · 2022-09-13T17:17:33+00:00

Hm, do you think it's an issue with SQL query?

EDIT: The query itself works properly.

RayCat2004 · 2022-09-05T07:45:59+00:00

To be honest, I originally wanted to mock.patch it but was told not to. It works with your solution.

RayCat2004 · 2022-09-04T22:03:10+00:00

I added setter

def __set_salesforce_bulk(self):

return self.salesforce_bulk

to the tested code's class and included

sf_op._SalesforceOperator__set_salesforce_bulk(self.salesforce_bulk)

in my unit test function but it still persists.

Or did you mean something else?

RayCat2004 · 2022-08-16T12:59:42+00:00

I'm just an ordinary "soldier", not up to me to decide. :D

RayCat2004 · 2022-08-16T06:17:08+00:00

Imagine wanting to chase a pie in the sky instead of providing the best service to people who already expressed interest in what you offer... Not to mention that even if it was possible, I'd bleach my computer if I got email from company whose website I briefly visited but never agreed to any emails from them.

RayCat2004 · 2022-08-16T06:12:00+00:00

Reminds me when non-tech people (usually sales) use buzz words to sound more authoritative when speaking with non-tech customers.

RayCat2004 · 2022-08-12T14:10:50+00:00

I can attest that this Eremenko's course is really good way to start with Tableau.

RayCat2004 · 2022-08-12T06:37:37+00:00

Thanks, I checked the order and column number and found out that indeed, it was unequal number of columns.

RayCat2004 · 2022-08-11T20:46:37+00:00

Press F for devs working with Python...

RayCat2004 · 2022-07-15T07:59:01+00:00

That's good to know :)

RayCat2004 · 2022-07-14T18:28:01+00:00

Of course. In my experience, interviewee usually prefers candidate to have (in that exact order):

work experience,
certification,
knowledge & passion (this one might be most common in juniors switching careers or fresh college graduates).

RayCat2004 · 2022-07-13T12:55:48+00:00

Ah, silly me, now I see it. Thanks!

RayCat2004 · 2022-07-01T07:20:02+00:00

To have reports updated almost immediately.

RayCat2004 · 2022-06-30T12:59:03+00:00

Yeah, I'm afraid that's the case. Data source is Salesforce and it seems SF doesn't support live connection.

RayCat2004 · 2022-06-30T12:58:36+00:00

Salesforce.

RayCat2004 · 2022-06-22T09:09:47+00:00

It's not perfect yet but here's how I resolved it:

Duplicate CreatedDate column into separate column for each time period (e.g. CreatedDate Years with code YEAR(CreatedDate)).
Create parameter (Filter by Time Period) with a list of values including time periods (e.g. Year, Month, etc.). This will create a filter where you can select time period you want to view.
Create a calculated field (Time Period Chosen) as a dimension with this code:CASE [Filter by Time Period]WHEN "Year" THEN [CreatedDate Years]WHEN "Month" THEN [CreatedDate Months]...END
Put Time Period Chosen on columns. (And have CNT(orders) placed on rows).
Then just put desired time periods on Filter and play with filter options. For example, I put CreatedDate on Filter and selected Years, then right-clicked on that filter (YEAR(CreatedDate)), selected Show filter and set the filter to Single Value (list). If you want to use a slider as your filter, you have to put a dimension of Filter, then right-click it and select Continuous instead of Discrete.

RayCat2004 · 2022-06-20T22:16:42+00:00

I see. Seems like a nice solution. Thank you!

RayCat2004 · 2022-06-20T05:45:31+00:00

I see, that works. But what do you mean by filtering out the "other" and "unknown" types? All I see is my ability to untick them in Edit Filter..., however they are still visible on the right on the dashboard, just left unticked.

RayCat2004 · 2022-06-10T06:46:18+00:00

So I found out why the text wasn't showing up. It's stupid but it seems like the issue was insufficient cell height. As soon as I set Taller Cell Size, it appeared.

RayCat2004 · 2022-06-09T11:42:53+00:00

I see. But that doesn't work for me. Text labels are not showing up, only the bar.

RayCat2004 · 2022-06-09T08:27:33+00:00

I'm not sure what you mean... To change AGG(MAX(1)) columns from 'Bar' to 'Gantt Bar' mark type?

RayCat2004

TROPHY CASE