Google Sheets IMPORTDATA() with no header

Question

I'm looking over the documentation for IMPORTRANGE() to remove the header row, but it looks like I cannot do that.

How would I remove a header row from an external data source I'm bringing into Google Sheets using IMPORTRANGE() ?

Example data:

A B C

1 2 3
4 5 6
7 8 9

But I only want:

1 2 3
4 5 6
7 8 9

Thanks

Answer 1

=QUERY(IMPORTDATA(<myUrl>),
       "SELECT * OFFSET 1", 0)

Selects all but the first row of the CSV, works because the 0 argument makes it consider the header a row that is then skippable.