Hi guys, I am ingesting Oracle metadata and for a...
# ingestion
f
Hi guys, I am ingesting Oracle metadata and for a specific view I am getting the error in the debug log file. The view is quite complex and I assume it is because of that. Also attached the view definition. I've tried to skip it during the ingestion, but it's not happening, maybe works only for tables.
Copy code
include_views: True
    table_pattern:
         deny:
            - "^(sco_sector_configuration_bbs).*"
g
You should be able to use the
view_pattern
option to skip that view
What happens if you run
SELECT text FROM all_views WHERE view_name=:view_name AND owner = :schema
(filling in your values for view_name and schema)
f
When querying I am getting the view definition, which is quite large.
I have tried with
view_pattern
, but it does not work. And strangely enough if I reverse and say
allow
that
view_pattern
, I do not get an error. But I still don't get the view loaded.
g
Looked into this a bit more - oracle DPI-1037 error indicates that the column is being truncated, which means it definitely is complaining about the size of the view. The view_pattern allow and deny fields are full match regexes, so my bet is that the allow pattern you added simply didn’t match anything
f
Is there anything you could do about that? I managed to ignore the views, but we have quite a lot of big ones.
g
Not too much I can do here - I’ll try to add something soon that can suppress the error and let the rest of ingestion continue, but I think actually ingesting those view definitions might end up pretty involved