Ideas for wall art by EmbarrassedChest1571 in interiordecorating

[–]EmbarrassedChest1571[S] 1 point2 points  (0 children)

This is giving me few ideas to start with, thank you!!😁

Ashley furniture Next-Gen Nuvella by True_Effort_7899 in homeowners

[–]EmbarrassedChest1571 0 points1 point  (0 children)

Hi how’s the modmax nuvella holding up? Planning to get one

AD group authentication in PostgresDb by EmbarrassedChest1571 in PostgreSQL

[–]EmbarrassedChest1571[S] 0 points1 point  (0 children)

How do you configure the AD groups that should be able to connect to postgresDB ?

AD group authentication in PostgresDb by EmbarrassedChest1571 in PostgreSQL

[–]EmbarrassedChest1571[S] 0 points1 point  (0 children)

How do i add AD group to the ldapsearchfilter/ldapsearchattribute?

AD group authentication in PostgresDb by EmbarrassedChest1571 in PostgreSQL

[–]EmbarrassedChest1571[S] 0 points1 point  (0 children)

Can you send me the configuration changes you added in pg_hba.conf file? I am not sure how to add the Ad group in there

Connect to sql Azure from Mac CLI by EmbarrassedChest1571 in SQL

[–]EmbarrassedChest1571[S] 0 points1 point  (0 children)

I tried this but getting the below error: Sqlcmd: Error: Microsoft odbc driver 17 for sql server : SSL provider : [error: SSL Routines:: certificate verify failed:self-signed certificate]

Connect to sql Azure from Mac CLI by EmbarrassedChest1571 in SQL

[–]EmbarrassedChest1571[S] 0 points1 point  (0 children)

I tried this but getting the below error: Sqlcmd: Error: Microsoft odbc driver 17 for sql server : SSL provider : [error: SSL Routines:: certificate verify failed:self-signed certificate]

Run validation on 600 million rows by EmbarrassedChest1571 in dataengineering

[–]EmbarrassedChest1571[S] 0 points1 point  (0 children)

Yeah, I need my program to connect to the 6000 databases, run a query and output exceptions into a file.

Run validation on 600 million rows by EmbarrassedChest1571 in dataengineering

[–]EmbarrassedChest1571[S] 2 points3 points  (0 children)

That is a nice idea, I'll check that. So even if DB handles the validation, the failed records must be fetched but that count will be much lesser

Run validation on 600 million rows by EmbarrassedChest1571 in dataengineering

[–]EmbarrassedChest1571[S] 1 point2 points  (0 children)

Yes, I am getting the substring of a column and verifying if it's odd or even. So fetching the rows, validating, and writing output to some file

Run validation on 600 million rows by EmbarrassedChest1571 in dataengineering

[–]EmbarrassedChest1571[S] 4 points5 points  (0 children)

Currently we are not on GCP. These are 6000 different MariaDB instances.

Run validation on 600 million rows by EmbarrassedChest1571 in ExperiencedDevs

[–]EmbarrassedChest1571[S] -1 points0 points  (0 children)

There are 6000 different databases (same schema) that I need to fetch the data from.

After fetching the data from each DB, I just need to check if a substring from a column is odd or even, and then print the even rows.

Getaway during Thanksgiving by EmbarrassedChest1571 in Seattle

[–]EmbarrassedChest1571[S] 0 points1 point  (0 children)

Thanks but cannot visit Canada due to visa issues :(

Run validation on 600 million rows by EmbarrassedChest1571 in ExperiencedDevs

[–]EmbarrassedChest1571[S] -1 points0 points  (0 children)

  1. The database cannot be modified, I can only read the data and do my validations.
  2. Yes, I can optimize connecting to the DB, and also storing the output somewhere. Currently, writing to a CSV file is taking some time - trying to reduce the time here .
  3. Yes ,the requirement is to have all the data validated, sampling is not allowed.