Closed Bug 964896 Opened 10 years ago Closed 10 years ago

Vertica access

Categories

(Data & BI Services Team :: DB: MySQL, task)

Product:
Data & BI Services Team
Component:
DB: MySQL
Type:
task
Priority:
Not set
Severity:
normal

Tracking

(Not tracked)

Status:
RESOLVED FIXED

People

(Reporter: kmag, Assigned: mpressman)

Details

(Whiteboard: [data: user perm]) 

I need access to Vertica, particularly read access to the table that backs https://dataviz.mozilla.org/views/FirefoxUserAdd-OnCounts/TopAddons#1

I'm eventually also going to need write access to a table to store metadata and join against the above.

Thanks.
Matt, can you give Kris the needed read access?

We'll address write access a bit later on.
Assignee: scabral → mpressman
It may take me awhile to figure out the table that backs that view in tableau. I'll check into it, but if perhaps aphadke would know offhand. aphadke, can you point me to the table in the description or point me to a data model where I can determine this?
Flags: needinfo?(aphadke)
Hey Matt,
f_fhr_addon_counts is the table name.
Flags: needinfo?(aphadke)
Credentials have been emailed
Status: NEW → RESOLVED
Closed: 10 years ago
Resolution: --- → FIXED
Whiteboard: [user perm]
Whiteboard: [user perm] → [data: user perm]
Product: mozilla.org → Data & BI Services Team
You need to log in before you can comment on or make changes to this bug.