Hi @FNavas-foundation: @Aitolkyn already should already have access to Superset as they are part of the analytics_privatedata_users group. @Aitolkyn, can you please confirm?

The only thing that can be updated here is that the contract end data is specified as:

expiry_date: "2024-05-01"
expiry_contact: diego@wikimedia.org

So we can extend that to 2024-09-01 but everything else should be fine.

@ssingh Thank you for checking! I get the following error when trying to access my tables:

mysql error: SELECT command denied to user 'research'@'10.67.30.187' for table `aitolkyn`.`domain_reverted_added_2019_2023`

Maybe I need to set anything before I can access those?

Unsure why @Aitolkyn isn't have access now then ://

As for the other stuff —

expiry_date: "2024-09-01"
expiry_contact: fnavas@wikimedia.org

In T362533#9713602, @Aitolkyn wrote:

@ssingh Thank you for checking! I get the following error when trying to access my tables:

mysql error: SELECT command denied to user 'research'@'10.67.30.187' for table `aitolkyn`.`domain_reverted_added_2019_2023`

Maybe I need to set anything before I can access those?

Hi @Aitolkyn: Can you share the query you are trying to run? While knowing nothing about this, shouldn't the user be aitolkyn here and the table name research? I may be wrong about this! It says table aitolkyn.

Change #1019824 had a related patch set uploaded (by Ssingh; author: Ssingh):

[operations/puppet@production] admin: update expiry_{contact,date} for aitolkyn

https://gerrit.wikimedia.org/r/1019824

In T362533#9713681, @ssingh wrote:

In T362533#9713602, @Aitolkyn wrote:

@ssingh Thank you for checking! I get the following error when trying to access my tables:

mysql error: SELECT command denied to user 'research'@'10.67.30.187' for table `aitolkyn`.`domain_reverted_added_2019_2023`

Maybe I need to set anything before I can access those?

Hi @Aitolkyn: Can you share the query you are trying to run? While knowing nothing about this, shouldn't the user be aitolkyn here and the table name research? I may be wrong about this! It says table aitolkyn.

The table name is "aitolkyn.domain_reverted_added_2019_2023" and my user name is "aitolkyn". I am running

SELECT *
FROM   aitolkyn.domain_reverted_added_2019_2023

Change #1019824 merged by Ssingh:

[operations/puppet@production] admin: update expiry_{contact,date} for aitolkyn

https://gerrit.wikimedia.org/r/1019824

In T362533#9714116, @Aitolkyn wrote:

In T362533#9713681, @ssingh wrote:

In T362533#9713602, @Aitolkyn wrote:

@ssingh Thank you for checking! I get the following error when trying to access my tables:

mysql error: SELECT command denied to user 'research'@'10.67.30.187' for table `aitolkyn`.`domain_reverted_added_2019_2023`

Maybe I need to set anything before I can access those?

Hi @Aitolkyn: Can you share the query you are trying to run? While knowing nothing about this, shouldn't the user be aitolkyn here and the table name research? I may be wrong about this! It says table aitolkyn.

The table name is "aitolkyn.domain_reverted_added_2019_2023" and my user name is "aitolkyn". I am running

SELECT *
FROM   aitolkyn.domain_reverted_added_2019_2023

The error message suggests you're trying to run that query in the analytics MariaDB replicas (using analytics-mysql or directly via mysql). This database only exists in Hive:

[urbanecm@stat1005 ~]$ hive --database=aitolkyn
[...]
hive (aitolkyn)> show tables;
OK
[...]
domain_reverted_added_2019_2023
[...]

Can you try querying for the data using eg. Hive (see https://wikitech.wikimedia.org/wiki/Analytics/Cluster/Systems/Hive)? Or when in Superset, using the presto_analytics_hive database?

In T362533#9716944, @Urbanecm_WMF wrote:

In T362533#9714116, @Aitolkyn wrote:

In T362533#9713681, @ssingh wrote:

In T362533#9713602, @Aitolkyn wrote:

@ssingh Thank you for checking! I get the following error when trying to access my tables:

mysql error: SELECT command denied to user 'research'@'10.67.30.187' for table `aitolkyn`.`domain_reverted_added_2019_2023`

Maybe I need to set anything before I can access those?

Hi @Aitolkyn: Can you share the query you are trying to run? While knowing nothing about this, shouldn't the user be aitolkyn here and the table name research? I may be wrong about this! It says table aitolkyn.

The table name is "aitolkyn.domain_reverted_added_2019_2023" and my user name is "aitolkyn". I am running

SELECT *
FROM   aitolkyn.domain_reverted_added_2019_2023

The error message suggests you're trying to run that query in the analytics MariaDB replicas (using analytics-mysql or directly via mysql). This database only exists in Hive:

[urbanecm@stat1005 ~]$ hive --database=aitolkyn
[...]
hive (aitolkyn)> show tables;
OK
[...]
domain_reverted_added_2019_2023
[...]

Can you try querying for the data using eg. Hive (see https://wikitech.wikimedia.org/wiki/Analytics/Cluster/Systems/Hive)? Or when in Superset, using the presto_analytics_hive database?

Got it! Thank you so much @Urbanecm_WMF!

Thanks indeed @Urbanecm_WMF! Nice catch. @Aitolkyn: the contract expiry and date have been updated. If this has been resolved for you, please feel free to the task.