| linkedin_connection_overview |
last_name |
TEXT |
/console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
[linkedin_connection_overview (view) Schema](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
/console/content/view/linkedin_connection_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_connection_overview.sql?stats=yes) |
[linkedin_connection_overview (view) Content](console/content/view/linkedin_connection_overview.sql?stats=yes) |
CREATE VIEW linkedin_connection_overview AS
SELECT
c."First Name" AS first_name,
c."Last Name" AS last_name,
c."Email Address" AS email,
c."Company" AS company,
c."Position" AS position,
c."Connected On" AS connection_date
FROM uniform_resource_connections c |
| linkedin_connection_overview |
email |
TEXT |
/console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
[linkedin_connection_overview (view) Schema](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
/console/content/view/linkedin_connection_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_connection_overview.sql?stats=yes) |
[linkedin_connection_overview (view) Content](console/content/view/linkedin_connection_overview.sql?stats=yes) |
CREATE VIEW linkedin_connection_overview AS
SELECT
c."First Name" AS first_name,
c."Last Name" AS last_name,
c."Email Address" AS email,
c."Company" AS company,
c."Position" AS position,
c."Connected On" AS connection_date
FROM uniform_resource_connections c |
| linkedin_connection_overview |
company |
TEXT |
/console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
[linkedin_connection_overview (view) Schema](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
/console/content/view/linkedin_connection_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_connection_overview.sql?stats=yes) |
[linkedin_connection_overview (view) Content](console/content/view/linkedin_connection_overview.sql?stats=yes) |
CREATE VIEW linkedin_connection_overview AS
SELECT
c."First Name" AS first_name,
c."Last Name" AS last_name,
c."Email Address" AS email,
c."Company" AS company,
c."Position" AS position,
c."Connected On" AS connection_date
FROM uniform_resource_connections c |
| linkedin_connection_overview |
position |
TEXT |
/console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
[linkedin_connection_overview (view) Schema](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
/console/content/view/linkedin_connection_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_connection_overview.sql?stats=yes) |
[linkedin_connection_overview (view) Content](console/content/view/linkedin_connection_overview.sql?stats=yes) |
CREATE VIEW linkedin_connection_overview AS
SELECT
c."First Name" AS first_name,
c."Last Name" AS last_name,
c."Email Address" AS email,
c."Company" AS company,
c."Position" AS position,
c."Connected On" AS connection_date
FROM uniform_resource_connections c |
| linkedin_connection_overview |
connection_date |
TEXT |
/console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
[linkedin_connection_overview (view) Schema](console/info-schema/view.sql?name=linkedin_connection_overview&stats=yes) |
/console/content/view/linkedin_connection_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_connection_overview.sql?stats=yes) |
[linkedin_connection_overview (view) Content](console/content/view/linkedin_connection_overview.sql?stats=yes) |
CREATE VIEW linkedin_connection_overview AS
SELECT
c."First Name" AS first_name,
c."Last Name" AS last_name,
c."Email Address" AS email,
c."Company" AS company,
c."Position" AS position,
c."Connected On" AS connection_date
FROM uniform_resource_connections c |
| linkedin_connection_count |
connection_count |
|
/console/info-schema/view.sql?name=linkedin_connection_count&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_connection_count&stats=yes) |
[linkedin_connection_count (view) Schema](console/info-schema/view.sql?name=linkedin_connection_count&stats=yes) |
/console/content/view/linkedin_connection_count.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_connection_count.sql?stats=yes) |
[linkedin_connection_count (view) Content](console/content/view/linkedin_connection_count.sql?stats=yes) |
CREATE VIEW linkedin_connection_count AS
SELECT
COUNT(*) as connection_count
FROM uniform_resource_connections |
| linkedin_top_skills |
skills |
TEXT |
/console/info-schema/view.sql?name=linkedin_top_skills&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_top_skills&stats=yes) |
[linkedin_top_skills (view) Schema](console/info-schema/view.sql?name=linkedin_top_skills&stats=yes) |
/console/content/view/linkedin_top_skills.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_top_skills.sql?stats=yes) |
[linkedin_top_skills (view) Content](console/content/view/linkedin_top_skills.sql?stats=yes) |
CREATE VIEW linkedin_top_skills AS
SELECT
Name AS skills
FROM uniform_resource_skills
ORDER BY skills ASC |
| linkedin_top_skills_count |
total_skills |
|
/console/info-schema/view.sql?name=linkedin_top_skills_count&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_top_skills_count&stats=yes) |
[linkedin_top_skills_count (view) Schema](console/info-schema/view.sql?name=linkedin_top_skills_count&stats=yes) |
/console/content/view/linkedin_top_skills_count.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_top_skills_count.sql?stats=yes) |
[linkedin_top_skills_count (view) Content](console/content/view/linkedin_top_skills_count.sql?stats=yes) |
CREATE VIEW linkedin_top_skills_count AS
SELECT
COUNT(Name) AS total_skills
FROM uniform_resource_skills |
| linkedin_employment_timeline_count |
time_line_count |
|
/console/info-schema/view.sql?name=linkedin_employment_timeline_count&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_employment_timeline_count&stats=yes) |
[linkedin_employment_timeline_count (view) Schema](console/info-schema/view.sql?name=linkedin_employment_timeline_count&stats=yes) |
/console/content/view/linkedin_employment_timeline_count.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_employment_timeline_count.sql?stats=yes) |
[linkedin_employment_timeline_count (view) Content](console/content/view/linkedin_employment_timeline_count.sql?stats=yes) |
CREATE VIEW linkedin_employment_timeline_count AS
SELECT
COUNT(*) as time_line_count
FROM uniform_resource_positions p |
| linkedin_employment_timeline |
company_name |
TEXT |
/console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes) |
[linkedin_employment_timeline (view) Schema](console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes) |
/console/content/view/linkedin_employment_timeline.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_employment_timeline.sql?stats=yes) |
[linkedin_employment_timeline (view) Content](console/content/view/linkedin_employment_timeline.sql?stats=yes) |
CREATE VIEW linkedin_employment_timeline AS
SELECT
p."Company Name" AS company_name,
p."Title" AS job_title,
p."Started On" AS start_date,
p."Finished On" AS end_date
FROM uniform_resource_positions p
ORDER BY start_date DESC |
| linkedin_employment_timeline |
job_title |
TEXT |
/console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes) |
[linkedin_employment_timeline (view) Schema](console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes) |
/console/content/view/linkedin_employment_timeline.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_employment_timeline.sql?stats=yes) |
[linkedin_employment_timeline (view) Content](console/content/view/linkedin_employment_timeline.sql?stats=yes) |
CREATE VIEW linkedin_employment_timeline AS
SELECT
p."Company Name" AS company_name,
p."Title" AS job_title,
p."Started On" AS start_date,
p."Finished On" AS end_date
FROM uniform_resource_positions p
ORDER BY start_date DESC |
| linkedin_employment_timeline |
start_date |
TEXT |
/console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes) |
[linkedin_employment_timeline (view) Schema](console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes) |
/console/content/view/linkedin_employment_timeline.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_employment_timeline.sql?stats=yes) |
[linkedin_employment_timeline (view) Content](console/content/view/linkedin_employment_timeline.sql?stats=yes) |
CREATE VIEW linkedin_employment_timeline AS
SELECT
p."Company Name" AS company_name,
p."Title" AS job_title,
p."Started On" AS start_date,
p."Finished On" AS end_date
FROM uniform_resource_positions p
ORDER BY start_date DESC |
| linkedin_employment_timeline |
end_date |
TEXT |
/console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes) |
[linkedin_employment_timeline (view) Schema](console/info-schema/view.sql?name=linkedin_employment_timeline&stats=yes) |
/console/content/view/linkedin_employment_timeline.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_employment_timeline.sql?stats=yes) |
[linkedin_employment_timeline (view) Content](console/content/view/linkedin_employment_timeline.sql?stats=yes) |
CREATE VIEW linkedin_employment_timeline AS
SELECT
p."Company Name" AS company_name,
p."Title" AS job_title,
p."Started On" AS start_date,
p."Finished On" AS end_date
FROM uniform_resource_positions p
ORDER BY start_date DESC |
| linkedin_learning |
title |
TEXT |
/console/info-schema/view.sql?name=linkedin_learning&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_learning&stats=yes) |
[linkedin_learning (view) Schema](console/info-schema/view.sql?name=linkedin_learning&stats=yes) |
/console/content/view/linkedin_learning.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_learning.sql?stats=yes) |
[linkedin_learning (view) Content](console/content/view/linkedin_learning.sql?stats=yes) |
CREATE VIEW linkedin_learning AS
SELECT
"Content Title" AS title,
"Content Description" AS description,
"Content Type" AS type
FROM uniform_resource_learning
ORDER BY 'Content Last Watched Date (if viewed)' DESC |
| linkedin_learning |
description |
TEXT |
/console/info-schema/view.sql?name=linkedin_learning&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_learning&stats=yes) |
[linkedin_learning (view) Schema](console/info-schema/view.sql?name=linkedin_learning&stats=yes) |
/console/content/view/linkedin_learning.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_learning.sql?stats=yes) |
[linkedin_learning (view) Content](console/content/view/linkedin_learning.sql?stats=yes) |
CREATE VIEW linkedin_learning AS
SELECT
"Content Title" AS title,
"Content Description" AS description,
"Content Type" AS type
FROM uniform_resource_learning
ORDER BY 'Content Last Watched Date (if viewed)' DESC |
| linkedin_learning |
type |
TEXT |
/console/info-schema/view.sql?name=linkedin_learning&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_learning&stats=yes) |
[linkedin_learning (view) Schema](console/info-schema/view.sql?name=linkedin_learning&stats=yes) |
/console/content/view/linkedin_learning.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_learning.sql?stats=yes) |
[linkedin_learning (view) Content](console/content/view/linkedin_learning.sql?stats=yes) |
CREATE VIEW linkedin_learning AS
SELECT
"Content Title" AS title,
"Content Description" AS description,
"Content Type" AS type
FROM uniform_resource_learning
ORDER BY 'Content Last Watched Date (if viewed)' DESC |
| linkedin_company_follows |
Organization |
TEXT |
/console/info-schema/view.sql?name=linkedin_company_follows&stats=yes |
[Content](console/info-schema/view.sql?name=linkedin_company_follows&stats=yes) |
[linkedin_company_follows (view) Schema](console/info-schema/view.sql?name=linkedin_company_follows&stats=yes) |
/console/content/view/linkedin_company_follows.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/linkedin_company_follows.sql?stats=yes) |
[linkedin_company_follows (view) Content](console/content/view/linkedin_company_follows.sql?stats=yes) |
CREATE VIEW linkedin_company_follows AS
SELECT
Organization
FROM uniform_resource_company_follows
ORDER BY 'Followed On' DESC |
| uniform_resource_file |
uniform_resource_id |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file |
nature |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file |
source_path |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file |
file_path_rel |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file |
size_bytes |
INTEGER |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_imap |
uniform_resource_id |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
name |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
ur_ingest_session_imap_account_id |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
email |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
host |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
subject |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
from |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
message |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
date |
DATE |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
ur_ingest_session_imap_acct_folder_id |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
ingest_account_id |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
folder_name |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
size_bytes |
INTEGER |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
nature |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
content |
BLOB |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap_content |
uniform_resource_id |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
[uniform_resource_imap_content (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
/console/content/view/uniform_resource_imap_content.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap_content.sql?stats=yes) |
[uniform_resource_imap_content (view) Content](console/content/view/uniform_resource_imap_content.sql?stats=yes) |
CREATE VIEW uniform_resource_imap_content AS
SELECT
uri.uniform_resource_id,
base_ur.uniform_resource_id baseID,
ext_ur.uniform_resource_id extID,
base_ur.uri as base_uri,
ext_ur.uri as ext_uri,
base_ur.nature as base_nature,
ext_ur.nature as ext_nature,
json_extract(part.value, '$.body.Html') AS html_content
FROM
uniform_resource_imap uri
INNER JOIN uniform_resource base_ur ON base_ur.uniform_resource_id=uri.uniform_resource_id
INNER JOIN uniform_resource ext_ur ON ext_ur.uri = base_ur.uri ||'/json' AND ext_ur.nature = 'json',
json_each(ext_ur.content, '$.parts') AS part
WHERE ext_ur.nature = 'json' AND html_content NOT NULL |
| uniform_resource_imap_content |
baseID |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
[uniform_resource_imap_content (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
/console/content/view/uniform_resource_imap_content.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap_content.sql?stats=yes) |
[uniform_resource_imap_content (view) Content](console/content/view/uniform_resource_imap_content.sql?stats=yes) |
CREATE VIEW uniform_resource_imap_content AS
SELECT
uri.uniform_resource_id,
base_ur.uniform_resource_id baseID,
ext_ur.uniform_resource_id extID,
base_ur.uri as base_uri,
ext_ur.uri as ext_uri,
base_ur.nature as base_nature,
ext_ur.nature as ext_nature,
json_extract(part.value, '$.body.Html') AS html_content
FROM
uniform_resource_imap uri
INNER JOIN uniform_resource base_ur ON base_ur.uniform_resource_id=uri.uniform_resource_id
INNER JOIN uniform_resource ext_ur ON ext_ur.uri = base_ur.uri ||'/json' AND ext_ur.nature = 'json',
json_each(ext_ur.content, '$.parts') AS part
WHERE ext_ur.nature = 'json' AND html_content NOT NULL |
| uniform_resource_imap_content |
extID |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
[uniform_resource_imap_content (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
/console/content/view/uniform_resource_imap_content.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap_content.sql?stats=yes) |
[uniform_resource_imap_content (view) Content](console/content/view/uniform_resource_imap_content.sql?stats=yes) |
CREATE VIEW uniform_resource_imap_content AS
SELECT
uri.uniform_resource_id,
base_ur.uniform_resource_id baseID,
ext_ur.uniform_resource_id extID,
base_ur.uri as base_uri,
ext_ur.uri as ext_uri,
base_ur.nature as base_nature,
ext_ur.nature as ext_nature,
json_extract(part.value, '$.body.Html') AS html_content
FROM
uniform_resource_imap uri
INNER JOIN uniform_resource base_ur ON base_ur.uniform_resource_id=uri.uniform_resource_id
INNER JOIN uniform_resource ext_ur ON ext_ur.uri = base_ur.uri ||'/json' AND ext_ur.nature = 'json',
json_each(ext_ur.content, '$.parts') AS part
WHERE ext_ur.nature = 'json' AND html_content NOT NULL |
| uniform_resource_imap_content |
base_uri |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
[uniform_resource_imap_content (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
/console/content/view/uniform_resource_imap_content.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap_content.sql?stats=yes) |
[uniform_resource_imap_content (view) Content](console/content/view/uniform_resource_imap_content.sql?stats=yes) |
CREATE VIEW uniform_resource_imap_content AS
SELECT
uri.uniform_resource_id,
base_ur.uniform_resource_id baseID,
ext_ur.uniform_resource_id extID,
base_ur.uri as base_uri,
ext_ur.uri as ext_uri,
base_ur.nature as base_nature,
ext_ur.nature as ext_nature,
json_extract(part.value, '$.body.Html') AS html_content
FROM
uniform_resource_imap uri
INNER JOIN uniform_resource base_ur ON base_ur.uniform_resource_id=uri.uniform_resource_id
INNER JOIN uniform_resource ext_ur ON ext_ur.uri = base_ur.uri ||'/json' AND ext_ur.nature = 'json',
json_each(ext_ur.content, '$.parts') AS part
WHERE ext_ur.nature = 'json' AND html_content NOT NULL |
| uniform_resource_imap_content |
ext_uri |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
[uniform_resource_imap_content (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
/console/content/view/uniform_resource_imap_content.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap_content.sql?stats=yes) |
[uniform_resource_imap_content (view) Content](console/content/view/uniform_resource_imap_content.sql?stats=yes) |
CREATE VIEW uniform_resource_imap_content AS
SELECT
uri.uniform_resource_id,
base_ur.uniform_resource_id baseID,
ext_ur.uniform_resource_id extID,
base_ur.uri as base_uri,
ext_ur.uri as ext_uri,
base_ur.nature as base_nature,
ext_ur.nature as ext_nature,
json_extract(part.value, '$.body.Html') AS html_content
FROM
uniform_resource_imap uri
INNER JOIN uniform_resource base_ur ON base_ur.uniform_resource_id=uri.uniform_resource_id
INNER JOIN uniform_resource ext_ur ON ext_ur.uri = base_ur.uri ||'/json' AND ext_ur.nature = 'json',
json_each(ext_ur.content, '$.parts') AS part
WHERE ext_ur.nature = 'json' AND html_content NOT NULL |
| uniform_resource_imap_content |
base_nature |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
[uniform_resource_imap_content (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
/console/content/view/uniform_resource_imap_content.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap_content.sql?stats=yes) |
[uniform_resource_imap_content (view) Content](console/content/view/uniform_resource_imap_content.sql?stats=yes) |
CREATE VIEW uniform_resource_imap_content AS
SELECT
uri.uniform_resource_id,
base_ur.uniform_resource_id baseID,
ext_ur.uniform_resource_id extID,
base_ur.uri as base_uri,
ext_ur.uri as ext_uri,
base_ur.nature as base_nature,
ext_ur.nature as ext_nature,
json_extract(part.value, '$.body.Html') AS html_content
FROM
uniform_resource_imap uri
INNER JOIN uniform_resource base_ur ON base_ur.uniform_resource_id=uri.uniform_resource_id
INNER JOIN uniform_resource ext_ur ON ext_ur.uri = base_ur.uri ||'/json' AND ext_ur.nature = 'json',
json_each(ext_ur.content, '$.parts') AS part
WHERE ext_ur.nature = 'json' AND html_content NOT NULL |
| uniform_resource_imap_content |
ext_nature |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
[uniform_resource_imap_content (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
/console/content/view/uniform_resource_imap_content.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap_content.sql?stats=yes) |
[uniform_resource_imap_content (view) Content](console/content/view/uniform_resource_imap_content.sql?stats=yes) |
CREATE VIEW uniform_resource_imap_content AS
SELECT
uri.uniform_resource_id,
base_ur.uniform_resource_id baseID,
ext_ur.uniform_resource_id extID,
base_ur.uri as base_uri,
ext_ur.uri as ext_uri,
base_ur.nature as base_nature,
ext_ur.nature as ext_nature,
json_extract(part.value, '$.body.Html') AS html_content
FROM
uniform_resource_imap uri
INNER JOIN uniform_resource base_ur ON base_ur.uniform_resource_id=uri.uniform_resource_id
INNER JOIN uniform_resource ext_ur ON ext_ur.uri = base_ur.uri ||'/json' AND ext_ur.nature = 'json',
json_each(ext_ur.content, '$.parts') AS part
WHERE ext_ur.nature = 'json' AND html_content NOT NULL |
| uniform_resource_imap_content |
html_content |
|
/console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
[uniform_resource_imap_content (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap_content&stats=yes) |
/console/content/view/uniform_resource_imap_content.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap_content.sql?stats=yes) |
[uniform_resource_imap_content (view) Content](console/content/view/uniform_resource_imap_content.sql?stats=yes) |
CREATE VIEW uniform_resource_imap_content AS
SELECT
uri.uniform_resource_id,
base_ur.uniform_resource_id baseID,
ext_ur.uniform_resource_id extID,
base_ur.uri as base_uri,
ext_ur.uri as ext_uri,
base_ur.nature as base_nature,
ext_ur.nature as ext_nature,
json_extract(part.value, '$.body.Html') AS html_content
FROM
uniform_resource_imap uri
INNER JOIN uniform_resource base_ur ON base_ur.uniform_resource_id=uri.uniform_resource_id
INNER JOIN uniform_resource ext_ur ON ext_ur.uri = base_ur.uri ||'/json' AND ext_ur.nature = 'json',
json_each(ext_ur.content, '$.parts') AS part
WHERE ext_ur.nature = 'json' AND html_content NOT NULL |
| ur_ingest_session_files_stats |
device_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
file_extension |
| ur_ingest_session_files_stats |
ingest_session_id |
VARCHAR |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
file_extension |
| ur_ingest_session_files_stats |
ingest_session_started_at |
TIMESTAMPTZ |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
file_extension |
| ur_ingest_session_files_stats |
ingest_session_finished_at |
TIMESTAMPTZ |
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
file_extension |
| ur_ingest_session_files_stats |
file_extension |
|
/console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes |
[Content](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
[ur_ingest_session_files_stats (view) Schema](console/info-schema/view.sql?name=ur_ingest_session_files_stats&stats=yes) |
/console/content/view/ur_ingest_session_files_stats.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
[ur_ingest_session_files_stats (view) Content](console/content/view/ur_ingest_session_files_stats.sql?stats=yes) |
CREATE VIEW "ur_ingest_session_files_stats" AS
WITH Summary AS (
SELECT
device.device_id AS device_id,
ur_ingest_session.ur_ingest_session_id AS ingest_session_id,
ur_ingest_session.ingest_started_at AS ingest_session_started_at,
ur_ingest_session.ingest_finished_at AS ingest_session_finished_at,
COALESCE(ur_ingest_session_fs_path_entry.file_extn, '') AS file_extension,
ur_ingest_session_fs_path.ur_ingest_session_fs_path_id as ingest_session_fs_path_id,
ur_ingest_session_fs_path.root_path AS ingest_session_root_fs_path,
COUNT(ur_ingest_session_fs_path_entry.uniform_resource_id) AS total_file_count,
SUM(CASE WHEN uniform_resource.content IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_content,
SUM(CASE WHEN uniform_resource.frontmatter IS NOT NULL THEN 1 ELSE 0 END) AS file_count_with_frontmatter,
MIN(uniform_resource.size_bytes) AS min_file_size_bytes,
AVG(uniform_resource.size_bytes) AS average_file_size_bytes,
MAX(uniform_resource.size_bytes) AS max_file_size_bytes,
MIN(uniform_resource.last_modified_at) AS oldest_file_last_modified_datetime,
MAX(uniform_resource.last_modified_at) AS youngest_file_last_modified_datetime
FROM
ur_ingest_session
JOIN
device ON ur_ingest_session.device_id = device.device_id
LEFT JOIN
ur_ingest_session_fs_path ON ur_ingest_session.ur_ingest_session_id = ur_ingest_session_fs_path.ingest_session_id
LEFT JOIN
ur_ingest_session_fs_path_entry ON ur_ingest_session_fs_path.ur_ingest_session_fs_path_id = ur_ingest_session_fs_path_entry.ingest_fs_path_id
LEFT JOIN
uniform_resource ON ur_ingest_session_fs_path_entry.uniform_resource_id = uniform_resource.uniform_resource_id
GROUP BY
device.device_id,
ur_ingest_session.ur_ingest_session_id,
ur_ingest_session.ingest_started_at,
ur_ingest_session.ingest_finished_at,
ur_ingest_session_fs_path_entry.file_extn,
ur_ingest_session_fs_path.root_path
)
SELECT
device_id,
ingest_session_id,
ingest_session_started_at,
ingest_session_finished_at,
file_extension,
ingest_session_fs_path_id,
ingest_session_root_fs_path,
total_file_count,
file_count_with_content,
file_count_with_frontmatter,
min_file_size_bytes,
CAST(ROUND(average_file_size_bytes) AS INTEGER) AS average_file_size_bytes,
max_file_size_bytes,
oldest_file_last_modified_datetime,
youngest_file_last_modified_datetime
FROM
Summary
ORDER BY
device_id,
ingest_session_finished_at,
file_extension |