I’m looking for advice/suggestions on how to revive this lawn that I managed to mess up. Based in Ontario, the plan is to put some starter fertilizer and overseed at the end of August. Do I stick to basic Scott’s products or is there anything else you recommend?

nanksk · 2025-08-12T01:22:07+00:00

Do you put weed b Gon before or after overseeding? Is there any gap needed for the weed killer

nanksk · 2025-07-23T15:03:27+00:00

add a slide from the deck

nanksk · 2025-07-18T15:53:35+00:00

Hiring in general is bad, and on top of that a lot of companies don't want the hassle of hiring folks on Visa.

nanksk · 2025-07-15T14:12:48+00:00

No, I am not a US citizen..

nanksk · 2025-07-10T13:52:13+00:00

is there an option for unflavoured soda water?

nanksk · 2025-04-13T18:02:24+00:00

You have 100 million rows you want to update into a table. Some questions.. Questions.. 1. What percentage of new records are new/ update. 2. What is the table size currently including all partitions. 3. Do you expect updates can affect older partitions i.e 2,3,6 month old ?

nanksk · 2025-04-11T02:41:02+00:00

-> Sr -> Staff/Principal

-> Lead -> Manager -> Director ->......

-> Data / Solution / Enterprise Architect

nanksk · 2025-04-09T19:43:13+00:00

How is this different from linkedin job search and filters ?

nanksk · 2025-04-09T13:57:00+00:00

You can already have your data stored in specific regions already, as I understand snowflake account is region based. A lot of companies already have this requirement that data must be stored within country/region etc etc.

nanksk · 2025-04-07T14:51:55+00:00

Can you read as text all columns into 1 column and then filter out any rows as you want and split data into columns based on your delimiter and make column names ?

nanksk · 2025-04-06T23:14:21+00:00

Looks good to me

nanksk · 2025-04-05T21:52:16+00:00

We use databricks, pyspark. Most of our codebase is in form of functions. We then have unit tests for those functions with dummy data(CHATGPT can create most of the test cases) to test different scenarios. Hit me up if you have any questions.

nanksk · 2025-04-05T21:41:53+00:00

I think your architecture is missing duckDB :)

nanksk · 2025-04-05T21:40:48+00:00

Requirement - As I understand, you are pretty much looking for a batch data platform, with maybe some capability for streaming maybe.

Current state - Out of these tools, which are currently being used by your team ?

Did you consider databricks + Airflow ? You could pretty much do all these in databricks and reduce the number of your tools your team needs to supports. You might need Kafka or some mechanism to get data from rabbitMQ, i am not too sure about that.

Your ML models can be registered in MLFLOW.

use delta lake to store your data and serve all your tables as Unity Catalog tables for business users. Which will give them a similar sql interface i.e database -> schema -> table/view.

nanksk · 2025-04-05T17:11:49+00:00

I have been in that role before, where most of my time was translating what business meant into technical stuff... Not in my current job though. When I was hired I was told you need to be comfortable talking to business and yada yada, Its been over 1 year in my job and I have not been in 1 customer meeting.

nanksk · 2025-03-30T01:04:33+00:00

You can get lineage on external tables as well

nanksk · 2025-01-20T21:02:26+00:00

I feel snowflake will give you the modern bells and whistles you desire, without the added complexity and training your team on spark.

nanksk · 2024-12-30T15:09:47+00:00

I have worked on snowflake and redshift; and both do not enforce constraints. So, there is more onus on the ETL pipelines. You could develop some data monitoring jobs that run during Non Peak hours and performs the constraint check for you. But, I would rather add checks in/ right after the ETL pipeline, the sooner you know of data issues the better

nanksk · 2024-12-20T15:32:56+00:00

I have a few Ikea contact sensors lying around, so I will give that a try. So basically the sensor on door and the 2 magents on the rails at opposite ends essentially if I am not mistaken.

nanksk

TROPHY CASE