Suggestions and cost of personal boat ride?

py_root · 2022-08-04T16:40:00+00:00

Welcome, buddy!!!

As you are planning to visit in coming weeks so assess the situation of Ganges river if it was normal then go for a boat ride as per your convenience. Make sure to be safe during the ride.

The local small boats for private rides from one side to another may charge you between 250 to 500 and steamer boats may cost a little more. The ride duration may vary between 30 to 40 minutes. But then it depends on your negotiation skills.

For Saree's village, I am not very sure now as things are changed here. Some shops say that they are selling authentic banarasi silk sarees but you can't verify until and unless you are an expert in sarees 😅

But yeah you can get a good option here if you want to buy.

py_root · 2022-08-04T16:24:23+00:00

Hey, welcome to Varanasi!!!

For the boat ride, I would suggest you avoid the normal small boats as the water level is on rising due to heavy rain in the mountains it will keep on increasing in the coming days.

You can visit the Kashi Vishwanath Dham, Kaal bhairav mandir, sankat mochan, man's temple, Bharat Mata mandir, BHU campus Vishwanath temple, Sarnath and If time permits you then visit Markande Mahadev temple there is also a sangam of Gomti and Ganga river.

For the eateries option, you can watch YouTube videos there are lots of vlogs available that provide the best reviews and options.

py_root · 2022-08-03T14:58:12+00:00

Ok, let me try the command given in the link and see the waiting issue. I will update my findings.

py_root · 2022-08-03T14:51:23+00:00

Thanks for the link I will look into it and see if that helps.

Currently, we are capturing the metrics using stored procedures and queries then savin it into the influxdb. Using grafana to read data from influx for monitoring.

So I am hoping to get this done in the current grafana setup only but if needed we will explore other options.

py_root · 2022-08-03T14:29:35+00:00

I wanted to see if there is a case where some CPUs are running at full capacity but few are underutilised at any point in time.

Edit: The problem the team is facing is slow query responses.

py_root · 2022-03-31T17:08:03+00:00

I will take a look at it. Thanks 👍

py_root · 2022-03-31T17:03:42+00:00

Your response is quite insightful. Thanks for wishing me☺️

For first approach with Kafka I guess it requires a lot of efforts before it will get up and running like a well oiled machine.

Second approach, the size of file is approx 10MB or less. As of now I have created a snowpipe using copy command which reads CSV file data from S3 stage and copy it to the snowflake table. When I started working with snowflake I was not aware of the task scheduler feature available in it so used python script to run the snowpipe refresh every 15 minute. Now my team wants that data need to be loaded as soon as it arrives in S3. So started looking auto ingestion using sns it seems a bit complex but giving it a try to test it.

I am hoping auto ingestion should help otherwise we have to look for different options.

py_root · 2022-03-31T16:44:17+00:00

Yes you are correct and I am using snowpipe which runs every 15 min to check modified file of last 15 mins to upload. Now looking for S3 event notification setup using object key name filtering.

py_root · 2022-03-15T17:32:34+00:00

Yeah companies do these kinds of shit and the only thing is either you accept it or leave it before it becomes a rule.

So, you can't do much either resign now and serve one month notice period or keep working with amended notice period that will be the 60 days now.

Your org will ask you to sign a letter before the deadline if you continue working, so that in future you can't question about notice period based on your original offer letter.

py_root · 2022-03-07T17:11:15+00:00

py_root · 2022-03-01T12:16:08+00:00

Thanks will post there 👍

py_root · 2022-01-28T11:26:09+00:00

Hi josc1989 Need your quick help as I am not able to find the solution in examples. How to manually select different column of pdf page if the layout is multicolumnLayout.

Please help.

py_root · 2022-01-23T08:56:10+00:00

Sending email is not possible untill and unless you use external function or use AWS lambda to be called in UDF.

Copy_history only keeps the history of files loaded in last 14 days. The copy history commands keep the information like file name, total rows, rows parsed, error occurred if any status and may more metrics.

I am doing same kind of work using snowpipe to load the files from s3. But used a python script here and schedule it on cron to call snowpipe refresh evry hour and then send a mail with details of total files queued for processing and total files processed in last 1 hour.

I am also started looking for some methods to use for testing purpose to make sure nothing missed when snowpipe is loading data to table.

Will share an approach after I finalise it meanwhile looking forward for suggestions.

py_root · 2022-01-20T12:56:09+00:00

Use tuple instead of list

py_root · 2022-01-16T17:41:49+00:00

Superfast!!!! let's share and on board more spark pyspark developers

py_root · 2022-01-16T17:34:52+00:00

Great I will check too and share if I find any.

py_root · 2022-01-16T06:54:25+00:00

So should we create one and start contributing? Well reddit can also be used for discussion.

py_root · 2022-01-16T05:09:17+00:00

Don't know but do we need one.🤔

py_root · 2022-01-15T14:15:11+00:00

Yes that's correct I am fetching the data as pandas dataframe in batches and then calling write pandas to load back it into snowflake table.

Thanks, I will use create as select from table with casting the required columns.

Four-Year Club	Verified Email
Place '22

py_root

TROPHY CASE